How can you accomplish union queries to combine multiple tables of similar structure.

this is the union query. I have 3 tables I want to get put into a 4th.

SELECT *
FROM T1
UNION ALL
SELECT *
FROM T2

INTO T4

????????

Well you can't do it in one go, you'll need 2 queries.

First make you union query of the 3 tables like you have and then make an Append query that you base off of the unionquery and insert into you fourth table.

Note using union queries like this smells like you have normalization issues.

JR