record number in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how I can create a new field in a query containing the record or row number for each record in that same query? This can be easily done with a make-table query, but I need to avoid that.
 
Here is a link to MVP Stephen Lebans' solution to this issue:

http://www.lebans.com/rownumber.htm



--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


nc said:
Does anyone know how I can create a new field in a query containing the
Click to expand...
record or row number for each record in that same query? This can be easily
done with a make-table query, but I need to avoid that.
 
You must log in or register to reply here.

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

Special characters 3
Access Dcount (multiple criteria) 3
Help with Query 1
Query to list records that don't match 6
union queries - with tables containing fields with attachments 2
Combining Multiple Like Values in a Query 1
Adding Sequential Numbers to a Query 1
Select Record in query, save as New Record then edit New Record 1

Back
Top