Tables in DB

[massa]

I have 10 tables in one db in access.They all have the same fields and some
have extra fields that others do not have. Can you advise how I would merge
all tables into one master table?
Any comments would be greatly appreciated. Thanks.

 

[Alex Dybenko]

Hi,
you can either make a new table with all required fields and put all data
there using insert queries, or make a union query which will bring you data
from all 10 tables

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[massa]

Thanks Alex,
Can you advise how to make a union query? Thanks.

 

[Alex Dybenko]

Hi,
you have to write sql like this:

Select field1, field2 from table1
union
Select field1, field2 from table2
union
Select field1, field2 from table3

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com