Multipe tables in access to combine....

[Bill]

I am having trouble deciding if access can do this, please
help. I have 6 tables, all with the same 4 fields that I
would like to combine into one query. they are joined to
one table by a common value. I am looking to create on
query with 5 total columns, one is the common field and
the other 4 are the common fields from the 6 tables. Can
this be done by access and if so HOW??

 

[Lynn Trapp]

Use a Union Query

 

[BigManT]

The answer is a union query as the other person stating. It might help you to know how to write one. Here is the construct

Select * from Table
unio
Select * from Table
unio
Select * from Table

All tables must have the same number of fields and in the same order. To get your fifth field do this

Select *, "DataEtc" as Column5 from Table
unio
Select *, "DataOkayYadayada" from Table
unio
Select *, "Yadayada" from Table

-BigManT