Thanks Anthony... I Actually figured it out as soon as I hit send! It's amazing, sometimes ***just*** emailing the group, you get the answer you need, before any body ever reads it!! :) April > > From: "Colli, Anthony G" <Anthony.Colli@xxxxxxx> > Date: 2003/01/21 Tue PM 01:18:26 EST > To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx> > Subject: [mso] Re: Sql Union to Select Into statements > > In Access SQL you can't write INSERT INTO tblNEW SELECT....UNION SELECT.... > it will return an error. You can save the union query and then write SELECT > INTO tblNEW SELECT * FROM myUnionQuery. > > -Anthony > > -----Original Message----- > From: 4office@xxxxxxxxxxxxx [mailto:4office@xxxxxxxxxxxxx] > Sent: Tuesday, January 21, 2003 12:01 PM > To: mso@xxxxxxxxxxxxx > Subject: [mso] Sql Union to Select Into statements > > > > I have this Union Query: > > SELECT * From [tblpress] UNION ALL SELECT *FROM [Parts Production] which > works fine as is... But I need to create a new table with these results... > > How do I add the Select Into [tblPressMerge] part of the sql statement to > make this a new table. > > Thanks, April > > ************************************************************* > You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or > MicrosoftOffice@xxxxxxxxxxxxxxxx > > To send mail to the group, simply address it to mso@xxxxxxxxxxxxx > > To Unsubscribe from this group, send an email to > mso-request@xxxxxxxxxxxxx?Subject=unsubscribe > > Or, visit the group's homepage and use the dropdown menu. This will also > allow you to change your email settings to digest or vacation (no mail). > //www.freelists.org/webpage/mso > > To be able to use the files section for sharing files with the group, send a > request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation > with instructions. Once you are a member of the files group, you can go > here to upload/download files: > http://www.smartgroups.com/vault/msofiles > ************************************************************* > > > ************************************************************* > You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or > MicrosoftOffice@xxxxxxxxxxxxxxxx > > To send mail to the group, simply address it to mso@xxxxxxxxxxxxx > > To Unsubscribe from this group, send an email to > mso-request@xxxxxxxxxxxxx?Subject=unsubscribe > > Or, visit the group's homepage and use the dropdown menu. This will also > allow you to change your email settings to digest or vacation (no mail). > //www.freelists.org/webpage/mso > > To be able to use the files section for sharing files with the group, send a > request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation > with instructions. Once you are a member of the files group, you can go here > to upload/download files: > http://www.smartgroups.com/vault/msofiles > ************************************************************* > ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************