How can I create a field in a query that will be AutoNumber?
Could you explain what you want to see? Autonumbers are a feature of
tables, not queries.
If you want to see a sequential line number on a Report, just put a
textbox on the report with a control source of 1 (just the number
one), and set its Running Sum property to "Over All".
If you want a sequential line number in a Query, starting with 1 and
counting up, it's a bit more difficult. You will need a field in the
query which you can count on as being unique (no duplicates) and
sorted in ascending order (I'll call it Sortfield); you can put in a
calculated field
LineNo: DCount("*", "queryname", "[Sortfield] <= " & [Sortfield])
John W. Vinson[MVP]
