Finding duplicates within a field

[Guest]

This is not a terribly difficult dilemma, but I need to know the easiest and
efficient way to deal with it.

I have one field full of email addresses. There are some duplicate records.
What's the best way to find the duplicate records in this field?

Thanks much in advance, for your time and feedback.

Jarrod

 

[[MVP] S.Clark]

Select Email, Count(Email) FROM Tablename Group By Email WHERE Count(Email)

 

[Guest]

Nevermind I figured it out. Just pasted them to a list and sorted, then
deleted the dupes I found.

Jarrod

 

[John Vinson]

This is not a terribly difficult dilemma, but I need to know the easiest and
efficient way to deal with it.

I have one field full of email addresses. There are some duplicate records.
What's the best way to find the duplicate records in this field?

Create a Query using the "Find Duplicates" query wizard.

John W. Vinson[MVP]

 

[John Vinson]

Nevermind I figured it out. Just pasted them to a list and sorted, then
deleted the dupes I found.

<sigh>

Let the computer do the work. Creative laziness is a wonderful tool!
Your technique would be fine for 200 addresses... but would you really
want to try it with 20,000?

John W. Vinson[MVP]