Combining data from 4 tables into 1

[Naz]

Hi All,

I have four tables all with identical fields. How do I
create a new table that combines all the records from all
four tables? Can anyone help?

Cheers

Naz

 

[Van T. Dinh]

Just use Append Queries to append Records from 3 Tables to the first Table.

 

[Sambantham Kuppusamy]

Naz,

As all the tables have yhe same columns use this:

Create a new union query as follows:

Select * from table1
union all
Select * from table2
union all
Select * from table3
union all
Select * from table4

save this query as query1 (or aany name)


writea second query: Query2:

Select * into newtable from query1


I hope this helps.


SAM