hi All

I need to have an auto number in an access query, this is not the auto number already existing in the table. I need a separate auto number field in the query which begins with 1 and is in increasing order.
Any help will be much appreciated

Look at "DemoqryANumA2000.mdb" (attachment).
You can do it in Query via Module (function), or via Report (without query, without module).
Look at table, query, module, Form1, (if you want via query, in any case I suggest to make a report).
Open Form1 and try.