jazzyt2u
05-03-2011, 02:23 PM
I have two tables and I want to combine them into a third table. Is this how I would do it because it's not working? And I don't know how to tell it to be put into the Third table.
Help please :-)
DoCmd.RunSql "Select TableA.Name, TableA.Address, TableA.City, TableA.Zip" & _
" From TableA" & _
" UNION " & _
" Select TableB.Name, TableB.Address, TableB.City, TableB.Zip" & _
" From TableB"
Help please :-)
DoCmd.RunSql "Select TableA.Name, TableA.Address, TableA.City, TableA.Zip" & _
" From TableA" & _
" UNION " & _
" Select TableB.Name, TableB.Address, TableB.City, TableB.Zip" & _
" From TableB"