In Memoriam Terms of Use
Queries: Find Unmatched records between two tables
(Q) How do I find all the records that are in one table but do not have matches in another table ?
(A) See MSKB article number Q95326 (online only), or use the new Query Wizards to create a "Not-In" query.