Numbering entries in a query

[stemar]

I have a small database of one main table from which I want to extract entries based on the values in a couple of fields. The query is sorted by date, oldest first. I need a field in the query which shows the number of the entry in the sorted query (Position_on_List in the example)

Position_on_List Name Application_Date Other fields...
1 Bloggs G 15/8/03 Other data...
2 Smith J 18/9/03 Other data...
3 Doe J 22/10/03 Other data...
etc.

(Sorry - I don't know how to make them line up)

Thanks in advance

 

[jmersing]

I'm not sure I understand, do you want to see the number in the first column in a seperate query?

Or do you want to count the numbers?

Try to re-phrase your question, I'm sure we can resolve it.
Jim