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

N

NYDCC

Does anybody know how to find duplicate contacts in Access 2002 without the
feature installed, and without the cd-rom?
 
D

Duane Hookom

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;
 
Top