T
Timmy
I need to create a new AutoNumber/Primary Key field in a make table query
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Ofer Cohen
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
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.
What you can do is create the table structure first and then use an append
query to add records to the table.
T
Timmy
I don't think I can do that because I'm combining two unrelated tables in my
query to create a sigle table
query to create a sigle table
T
Timmy
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.