Auto Number in Make Table Query SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a table with the "Select Into..." SQL statement so
that when the table is created, the autonumber is already created (with a
starting value of 1)?

I don't want to create the autonumber after the table is created, rather I
want the SQL statement to do it for me.

Thanks
 
sherwinb said:
Is it possible to create a table with the "Select Into..." SQL statement so
that when the table is created, the autonumber is already created (with a
starting value of 1)?

I don't want to create the autonumber after the table is created, rather I
want the SQL statement to do it for me.
Click to expand...


No. If the source table has an autonumber field, those
values will be copied to the new table. If it doesn't have
one, there there is no way for the new table to know that
you would like one to be created.

You can get that effect by creating the new table with all
its fields and their attributes first and then using an
Append type query. You can pre-create a "template" table
with no data and then use CopyObject to make a working copy.
 
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

Do You Have A SQL Query For This Problem? 1
Concantenation HELP! 6
Access Access 2010 import/append data into table w/o overwriting existing records 0
Access stripping decimal places in query 1
Access 2010 query for 3 tables 0
Access 2010 Form Issue's 0
VBA - retrieve data on last create named range from previous inserted named range 0
How to Populate Data from a table to another 0

Back
Top