Merge / Join tables access 2000

[CB]

Would appreciate easy way to join or combine 2 tables
created from query to create 1 table.

Each table has the same number and field names with some
different info within some fields. One table has primary
key the other without. Will I need to create primary key
for both tables, etc.

And how do you take a saved query and convert it to a
table.

Thanks much.

 

[John Vinson]

Would appreciate easy way to join or combine 2 tables
created from query to create 1 table.

Either a UNION query (see UNION in the online help) or use an Append
query to append the records from one table into the other table.

Each table has the same number and field names with some
different info within some fields. One table has primary
key the other without. Will I need to create primary key
for both tables, etc.

The resulting table should have a Primary Key obviously (*all* tables
should have a Primary Key). It needn't be an autonumber, just so it's
unique and stable. Is the PK in the table that has one an autonumber,
or something else?

And how do you take a saved query and convert it to a
table.

By opening the query in design mode and using the Query menu option
(or the query type toolbar icon) to change it into a MakeTable query.
You'll be prompted for the name of the output table.