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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create table query... want to insert autonumber column 3
Make Table Query and Autonumber Fields 6
Append query - Append to table with Autonumber field 2
Links in Query results 3
Trouble with Query Results 11
Update query with autonumber field 4
Append Query: SQL to add a new record? 7
How do you create an autonumber column in a query? 2

Back
Top