Delete Query

[Mojo1]

DELETE *
FROM dbo_idfy
WHERE PEOPLE_CODE_ID NOT IN (SELECT
dbo_ACADEMIC.PEOPLE_CODE_ID
FROM dbo_ACADEMIC INNER JOIN dbo_idfy ON dbo_ACADEMIC.PEOPLE_CODE_ID =
dbo_idfy.people_code_id
WHERE (((dbo_ACADEMIC.ACADEMIC_YEAR)=[Enter Academic Year]) AND
((dbo_ACADEMIC.ACADEMIC_TERM)=[Enter Academic Term]) AND
((dbo_ACADEMIC.ACADEMIC_SESSION)="01") AND ((dbo_ACADEMIC.ACADEMIC_RATING)
="Here")));

What can I do to make this work? When I try to run ithe query it just sits there.

 

[SydneyGeek]

Try turning it into a SELECT query. When you run it do you get any records?
If not, take a look at the query grid and check the links. Sometimes, instead of (say) 3 tables llinked in a chain, you end up with an extra link (because of Autojoin) that closes the loop. You won't get records that way.
Whatever, play with the query until you see the records that you want to delete. Then change it back to a DELETE query.

HTH
Denis