How can I create a new AutoNumber(Primary Key) in a query

G

Guest

It is better to create a table with all the keys/index/properties you want,
and then use an append query, instead of using a create table query
Run a query to delete the data from the table, and then append the new data
 
J

John Spencer

As far as I know you can't.

What you can do is create the table structure first and then use an append
query to add records to the table.
 
G

Guest

I don't think I can do that because I'm combining two unrelated tables in my
query to create a sigle table
 
G

Guest

Thanks I'll try that

John Spencer said:
As far as I know you can't.

What you can do is create the table structure first and then use an append
query to add records to the table.
Click to expand...
 

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

Append to table with 2 fields in Primary Key - last is an autonumb 1
Primary Key AutoNumber Field 1
Access 2010 Form Issue's 0
Append Query To Table 3
Make Table Query and Autonumber Fields 6
Changing existing primary key to autonumber 2
Fixing up field with a row number to become PK 1
INSERT INTO With AutoNumber field 3

Top