In Access I need to merge 5 tables into 1 master table.

G

Guest

I have entered historical data that I have taken from 5 different books of
funeral records in our county. I made 5 different tables with this
information, and I would like to merge them into one master table to work
with this information more easily. Any ideas how I might do this?
 
G

Guest

You can do this using separate Append queries, or you can create a single
Union query that creates one data set for all 5 tables. Then you can use the
results of this query to write to the master table.
 

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 TABLES IN ACCESS 3
Merge or Combine Tabels 4
Merging of Tables in One New Table 5
Merge two tables 1
Merge 2 tables into 1 1
Merge Two Tables 1
Integrating information updates from satellite table to master tab 2
Append 5 Tables to One Table Nightly 2

Top