AutoNumber

[galsaba]

How can I create a field in a query that will be AutoNumber?

Thanks,

galsaba
(e-mail address removed)

 

[Rick B]

You would create the field in your TABLE.

 

[John Vinson]

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]