Combine Tables

  • Thread starter Thread starter Alchemist61
  • Start date Start date
A

Alchemist61

Hi Guys,
Can you advice me how to create a query that will combine a total of six
tables with identical Fields? Please explain in simple terms.
Thank you very much.
 
Use a Union Query
To get details, open VBA Help. From the Table of Contents select Microsoft
Jet SQL Reference, Data Manipulation Language, Union Operation
 

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

Combine Duplicates in Query 0
Combine Tables with Similar Fields 2
Extract info from Multiple Tables & combine into 1 1
Combine and Insert query 7
combine like items in query 1
Make-table query with around 2 ml records taking too long 0
Combine the Unique data 1
Query to combine 2 tables 2

Back
Top