Finding duplicates within a field

E

ExcessAccess

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
 
E

ExcessAccess

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

Jarrod
 
J

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?
Click to expand...

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

John W. Vinson[MVP]
 
J

John Vinson

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

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