make table query with autonumber?

R

Ron

Is there any way to have a make table query insert an
autonumber into the query it is making?
 
M

Michel Walsh

Hi,


Create the table first, then append the records in a second step.


Hoping it may help,
Vanderghast, Access MVP
 

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

Adding data to MS Access from csv file 0
Autonumber field in Excel that behaves the same as Access 0
Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Re-number an Autonumber 4
comparing table values 1
Autonumber records inserted in gaps 0
What are AutoNumber Dangers 11

Top