Listing numbers in field?

[hockeyadc]

I'm adding a bunch of rows with data into a table, and one of my fields is "ID number", which is just basically number the row in consecutive order before duplicates are removed. How can I make a query that will do this? So for instance the query would fill in "1", "2", "3", etc. depending on how many rows have information in them.

 

[hockeyadc]

I need to make some kind of loop, is that possible in access?

 

[Alansidman]

If you are willing to have your query used as a record source for a report, then here is a solution:

http://www.datapigtechnologies.com/flashfiles/linenuminreport.html

There may be other solutions but this is the only one that comes to me now.

Alan