How do I find duplicates in Access 2002 without the install cd-rom

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anybody know how to find duplicate contacts in Access 2002 without the
feature installed, and without the cd-rom?
 
Next time please provide more information about your table structure.
Generically, create a query like:
SELECT ContactName, Count(*) as NumOf
FROM tblContacts
GROUP BY ContactName
HAVING Count(*) >1;
 
Back
Top