I have some Delete Query code taken from the Access query GUI which brings up 'Specify the table containing the records you want to delete'. (I have set up complete referential integrity in all joins). Unfortunately I do not yet understand SQL very well, but after reading your forums I believe there are ways to re-write this code to make it work. Because it is a 'one off'' the code does not have to be efficient or quick. I'd be very grateful if anyone can re-code it for me.
DELETE Employees.[Employment Status], Availability.[Available From]
FROM Employees INNER JOIN Availability ON Employees.[Employee ID] = Availability.[Employee ID]
WHERE (((Employees.[Employment Status])="Potential") AND ((Availability.[Available From])<#1/1/2012#));
DELETE Employees.[Employment Status], Availability.[Available From]
FROM Employees INNER JOIN Availability ON Employees.[Employee ID] = Availability.[Employee ID]
WHERE (((Employees.[Employment Status])="Potential") AND ((Availability.[Available From])<#1/1/2012#));
Last edited: