Helpfulbox Now Offers Free POS Software for restaurants, kiosk, and any other retails business completely free used windows cashier system or as full blown POS. You will able to print to kitchen, display orders on the kitchen screen, manage inventory, employee, report, customer loyalty offers, employee management, delivery address track and much more, al for free.

insert the result of union sql into another table

By: Guest
Date: Fri-May-22-2009-
Response
2
try something like this

insert INTO [tablename] Select * FROM [savedquery] union and more select goese here;

[d] By: Guest
Date: Fri-May-22-2009
Response
2
i had EXACTLY the same problem

through almost a days research online i have come up with very few solutions ... none of which worked for MS Access.

however, the solutions given gave me ideas for other ways in which I could get around it.

I basically saved my select query (with multiple unions) and then

select * into [newtable]

from [savedquery]

works perfectly (including deleting info from [newtable] before it inserts, saves adding that to the code i wanted)

[d] By: Guest
Date: Fri-May-22-2009
Response
What is 1 + 100



Helpfulbox Now Offers Free POS Software

for restaurants, kiosk, and any other retails business completely free. It can be used as windows cashier system or as full blown POS. You will able to print to kitchen, display orders on the kitchen screen, manage inventory, employee, report, customer loyalty offers, employee management, delivery address track and much more, all for free.

Just Updated::