Auto Number in query design

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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?
 
I am asking for an expression which I could use to generate the autonumber
for the new column in the query design.
 
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
 
Back
Top