Folks,

I want to save the results of a union query into a new table with MS Access.

select numericol_1 from table1 UNION select numericol_2 from table2

Normally, MS Access uses syntax:

select column1, column2, ... INTO newtable from oldtable where clause

However, I cannot get the INTO newtable syntax to work with the UNION.

I've tried creating an empty table (using create table) then using the

INSERT INTO select numericol_1 from table1 UNION select numericol_2 from table2

but that fails, too.

The MS Access help doesn't help & neither do my two reference texts.

My only success has been to run the union query & then use the pull down menu options save as but of course a non-programmatic solution is no solution as far as I'm concerned.

Thx, LTC Doug McAllaster McAllasterD@Lee.Army.Mil