You cannot use a Make Table query in a UNION. If you want the result of this Union stored in another table, create the simple Union and then use it as input to a separate Make Table query.
But I'm not sure your query makes sense - why do you want names and cities in one column and addresses and countries in another? John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of sandeep ta Sent: Thursday, August 11, 2005 1:55 AM To: [email protected] Subject: [ms_access] Help Needed Hello, I want to create a table using two different queries output using union. But its giving an error the code is as below select name,address into temp from table1 union select city,country from table2. Can anyone help me to solve the problem i am facing Sandeep T.A [Non-text portions of this message have been removed] Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hrb4j1c/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123772308/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
