CODEWITHSUNDEEP
ms-access-2013
kitus
kitus

Reputation: 25

combine multi tables to one table in MS access 2013

I have 7 tables of information, all tables have the same fields. I would like to combine the tables into 1 master table and then make a report and show this master table on the report.

Any and all assistance would be greatly appreciated.

Upvotes: 1

Views: 47

Answers (1)

sagi
sagi

Reputation: 40481

You are looking for the sql query for that?

CREATE Master_Table as (
SELECT * FROM Table1
UNION ALL
SELECT * FROM Table2
UNION ALL 
SELECT * FROM Table3
...........)

That is if all the tables has the exact same fields(number and type)

Upvotes: 1

Related Questions