Serial number in Queries

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
 
A

Allen Browne

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
 
J

John Spencer

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
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Serialize function and Make Table Query 1
Serial Number - Temporarily In A Query 7
Showing number series in query for grouped items 5
append query creating new records 2
parameter query 1
Access Macro Repeat Expression using value of a field in table 0
update query using like criteria 3
Criteria of One query based on a field in another query 2

Top