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

L

Leslie

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

mray29

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

Page numbering with Merged Document and IF statements 1
COMBINE TABLES IN ACCESS 3
Mail Merge query 1
Merge or Combine Tabels 4
Find Duplicates in one column and sum other column 1
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Merging of Tables in One New Table 5
update a secondary table based on the master table 3

Top