Serial number in Queries

  • Thread starter Thread starter Ken®
  • Start date Start date
K

Ken®

I am just wondering how to make the serial number through query, and it's not
related with any data or table
Means once I run query there is data will be show and I want to be serial
number shows in the first of each raw.
Ken
 
Create a table that has the fields matching your query, plus an AutoNumber.
Turn it into an Append query, and append the data to the table. The
AutoNumber field gives you the sequence.

If you need to programmatically reset the seed of the AutoNumber after you
delete the data, see:
http://allenbrowne.com/func-ADOX.html#ResetSeed
 
If you mean that you want a row number then the news is that Access does not
have row numbers.

You can create a ranking number but that must be related to the data you are
displaying.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top