|Date: ||Tue, 29 Oct 2002 15:18:24 -0500|
|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|
|Content-Type: ||text/plain; charset="iso-8859-1"|
I want to save the results of a union query into a new table with MS Access.
Normally, MS Access uses syntax:
select column1, column2, ...
However, I cannot get the
syntax to work with the UNION.
I've tried creating an empty table (using create table)
then using the
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
LTC Doug McAllaster