Delete query

[AlexSalvadori]

I have a table full of employee details, and an updated version of this table, Employees2, which was uploaded from an excel file. In E2 there are changes to the records, but some records have been deleted altogether, it is the most relevant version of the two tables in all ways except one... E1 currently holds some documentation, attachment fields for .PDF and .DOC etc (which was lost when exported/imported in E2).



I know how to update E1 with the new data from E2, but I don't know how to delete the records in E1 that were deleted in E2 without going through them all manually. I'm thinking a delete Query matching the ID from E1 and E2, with a condition that says delete E1 where it does NOT equal E2 (ie, if its not in E2, delete it from E1.) But I don't know how to do this...

here's what I've tried so far, but when I try to run it it tells me to specify the table containing records i want to delete...

DELETE [Employees1].EmpDetID
FROM [Employees1] INNER JOIN [Employees2] ON [Employees1].EmpDetID = [Employees2].EmpDetID
WHERE ((([Employees1].EmpDetID)<>[Employees2]![EmpDetID]));

Please help

[JoeM]

If I understand it correctly, you just want to delete people in Employees1 who are not in Employees2?
Here is one way:

DELETE [Employees1].*
FROM [Employees1] 
WHERE [Employees1].EmpDetID Not In
(SELECT [Employees2].EmpDetID
FROM [Employees2]);

[AlexSalvadori]

that is exactly right thanks very much