Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to take 7 tables and combine them into 1 table.

How do I do that using a query, I basically want to addend the tables. Can
I do that in 1 query rather then writing 7 addend queries.

Thanks for your help.
 
Jeff

I suspect you are considering an "append" query. Since you have seven
different sources (your seven tables), you need 7 append queries.

If all 7 tables have the same structure, you could create a single query on
one of the 7, then copy it and "point" the copy at the 2nd table, and so on.

If the 7 tables do not have the same structure, why are you combining them?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

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

Arithmetic in a Table Row.... 3
returning an array from a function 3
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Data Mismatch in Excel 2010 4
Report Query 4
<>0 criteria in query does not work 1
Access Dcount (multiple criteria) 3
Append more then one table 8

Back
Top