I am trying to move data from one table to another. I have 2 codes that work right now... One to copy the data I want from one table to the other and one to delete data from a table. Is there any way I can get this to work as one whole process or do I need to run these seperatly?
INSERT INTO SoldMotors ( NTS, Make, Model, Grade, Date_Sold, Account, Invoice, Sold_Price, Core, Warranty, Lead )
SELECT Master.NTS, Master.Make, Master.Model, Master.Grade, Master.Date_Sold, Master.Account, Master.Invoice, Master.Sold_Price, Master.Core, Master.Warranty, Master.Lead
FROM Master
WHERE (((Master.Sold)="Yes"));
and this is my delete.
DELETE Master.NTS, Master.Make, Master.Model, Master.Grade, Master.Date_Sold, Master.Account, Master.Invoice, Master.Sold_Price, Master.Core, Master.Warranty, Master.Lead, Master.Sold
FROM Master
WHERE (((Master.Sold)="Yes"));