Date:         Tue, 29 Oct 2002 15:18:24 -0500
Reply-To:     mcallasterd@LEE.ARMY.MIL
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "McAllaster, Douglas L. LTC" <mcallasterd@LEE.ARMY.MIL>
Subject:      OT: MS Access - save union query results into newtable
Comments: To: SAS-L@UGA.CC.UGA.EDU
Content-Type: text/plain; charset="iso-8859-1"

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