I've created an append query to move records from one table to another. Am i right in thinking it should move the records then delete them from the previous table? If so then for some reason its not working for me. Using MS Access 2003.
INSERT INTO Tbl_Job_Temp SELECT Tbl_Job_List.* FROM Tbl_Job_List WHERE (((Tbl_Job_List.[Date of Visit])<=Now()-120));
Above is the Sql Code for the current query. Also is it possible to append to two different tables? If is it possible to run two queries at the same time on event click of a command button?
INSERT INTO Tbl_Assign_Temp SELECT Tbl_Assign_Engineer.* FROM Tbl_Job_List INNER JOIN Tbl_Assign_Engineer ON Tbl_Job_List.[Job ID] = Tbl_Assign_Engineer.[Job ID] WHERE (((Tbl_Job_List.[Date of Visit])<=Now()-120));
Thanks in advance TG