In Memoriam Terms of Use
Queries: Find Duplicate key values
(Q) How do I find duplicate key values?
(A) To find duplicate records and edit the records or choose which record to keep, use the Find Duplicates Query Wizard in Microsoft Access 2.0 and later.