Removing duplicate detail records

[John]

Hi

I have a contacts table with four fields Contact_ID, Company_ID, Forename
and Surname. As a result of recent data import, many companies have ended up
with duplicate contacts, so for instance Company_ID 109 will have multiple
contacts with the same forename and surname. What is the way to remove such
duplicates such that each company is left with only one contact of a
specific forename+surname set?

Thanks

Regards

 

[ruralguy via AccessMonster.com]

Have you tried using the Find Duplicates Query Wizard?

 

[John]

How does one delete all duplicate records except one? That is my problem.

Thanks

Regards

 

[ruralguy via AccessMonster.com]

I would think one way would be to use the Find Duplicates Query until none
can be found.

How does one delete all duplicate records except one? That is my problem.

Thanks

Regards

Have you tried using the Find Duplicates Query Wizard?

[quoted text clipped - 12 lines]