For every record that a query gives I need a field in the query that counts starting from 1001. Every time I show the results of this query the first record has to start with 1001.

How can I accomplish this?

Thx

Alexandre (channeling Dev Ashish) already posted a possible answer in your identical topic here: http://www.access-programmers.co.uk/ubb/Forum3/HTML/002923.html

Somos agni.

David R