Combine / Join Tables

[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.

 

[Nikos Yannacopoulos]

Last question first: Open your saved query in design view
and from the Query menu choose Make Table.
Once you have the table: make a query on the other table,
and this time make it an Append query; this will add the
records of the second table to the one you made in the
previous step.

HTH,
Nikos