Auto Number in query design

[Kevin]

Hi, I am using a query to create a data table, in the query, i would like to
add a new autonumber column (just autonumber the row), is there a function I
can do this easily?

 

[Kevin]

I am asking for an expression which I could use to generate the autonumber
for the new column in the query design.

 

[TedMi]

You need to create an empty table with one field of Autonumber type, and the
other fields as required. Then use an Append query to populate the data -
leave the autonumber column out of the inserted fields list; it will be
generated automatically.
-TedMi