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;
 
I'm sorry for the lack of information, I am a very beginner Access user.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate fields in Access Database 2
Duplicates in union query 3
Find Duplicates Query 2
Duplicate Query 3
Panasonic cf-29 boot from CD 0
Access Auto Matching Duplicates? 0
OUTLOOK 2002 1
Game Emulators for Windows 10 4

Back
Top