Combine two Tables

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?
 
P

Peter Cole

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

Guest

I have to think about whether or notthere may be a
problem.

Thanks for the ideam,
Mark
 

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

Linked Tables - adding field and getting overflow error 1
Combine Duplicates in Query 0
Joining tables 1
Recordset not updateable 2
Simple question about query result 2
Combine Query and Table 1
Combine and Insert query 7
Combine two fields in a query to get a unique third one. 4

Top