Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Ms access query - add a serial/record number?
Unique for the query. Needs to sequential and incremental. Now it starts at +1 number of records and is incremented by1 on each record. i want it to start at 1 for each query- matthewra
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Ms access query - add a serial/record number?
I used this: http://support.microsoft.com/kb/94397 how can query call the SetToZero() first this is for novice users who will want to add the capability to a large set of yet to written queries- matthewra
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Ms access query - add a serial/record number?
Can I add a sequence number/serial number to any MSaccess query? Select * from A where ... order by ... e.g. A has 3 fields, A1, A2, A3 Select a1,a2,a3 from A where a1 <> "x" order by a2 and have 4 columns including a serial number for the records....- matthewra
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
