Combine two Tables

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have two tables (that have the same field definitions)
that I want to combine and run through the same query.

I don't want to run an "Append" query first.

Any suggestions?
 
run a UNION query to join the 2 tables before your query.
You have to type the SQL for the UNION directly into the
query. look at 'Union queries' in Access help.
One way to start is to open a query on one of the tables
then in design - View SQL then cut and paste as
required. Might be a problem if you want to update info
in the resulting query.
 
Back
Top