Finding records whose ID is NOT IN another record set

[Van T. Dinh]

A Left Outer Join should do:

SELECT tblProperty.*
FROM tblProperty
LEFT JOIN qryActiveProperties
ON tblProperty.[Property ID] =
qryActiveProperties.[Property ID]
WHERE qryActiveProperties.[Property ID] IS Null

HTH
Van T. Dinh
MVP (Access)