Combine Results 1

[awesomeBA]

I'd like to use the results of two querys to create a table. Both contain the same column names and properties.

Can you help with the best approach? I tried teh wizard it was a not go? Pprobably ID10T user error

 

[PHV]

SELECT * INTO NewTable
FROM (SELECT * FROM query1 UNION ALL SELECT * FROM query2) AS U;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[awesomeBA]

On the money as usual !!! Have a star!!!