AutoNumber in Query

  • Thread starter Thread starter Chris Wood
  • Start date Start date
C

Chris Wood

Hi,

I need to add an autonumber to my query results. I can run
a select query, or make table query if need be. Please
note that make table queries use a select statement, not a
create statement. How do I add an autonumber field?

Thanks,

Chris
 
Chris,

You could have a table with the requisite fields from your existing
query, plus an autonumber field, and then use an Append Query to put
the data from your query into the table.

If this doesn't help, maybe you could explain a bit more about your
purpose, as this is an unusual thing to want.

- Steve Schapel, Microsoft Access MVP
 
Back
Top