Combining Access Tables - Identical fields

[PghYoPro]

Hi all,

I have four tables with identical fields that I would like to combine into one master table. What is the easiest way to do so?

From reading, it seems a UNION ALL might do the trick; not sure what I am doing incorrectly:

Select * from ECP1
Union All

Select * from ECP2
Union All

Select * from ECP3
Union All

Select * from ECP4

I keep getting the error:

"Syntax error in FROM clause"

 

[Micron]

I don't do this often but I think the answer is that you can't use wildcard for all fields in a Union query. So
SELECT field1, field2... FROM tblMyTable1
UNION (or UNION ALL)
SELECT field1, field2... FROM tblMyTable2
etc

 

[xenou]

this works fine for me.


SELECT * from Inventory1
union all
select * from Inventory2
union all
select * from Inventory3
union all
select * from Inventory4


I don't see where you are creating a new master table anywhere, though. In the original post is that the actual query you were using?