Removal of Duplicates Queries

[ahaines]

Hi all
Ok have been given a DB with lots of E-mail address.
Have run a query to find Duplicates.
Have found Duplicates (lots of them)
Now how can I use access to get rid of the Duplicates
enters but keep the one of them
I hope I make sense.

Thanks for the help

 

[Roger Carlson]

On my website, see sig below, is a small sample database called
"RemoveDuplicates.mdb" which illustrates how to do this.

 

[Dale Fye]

A.

If all you have in the table is email addresses, you could just write
a distinct or GroupBy query to give you only one instance of each
email address.

SELECT Distinct [EmailAddress] FROM yourTable

If you need this in a separate table, change the query from a SELECT
to a Make-table query.

--
HTH

Dale Fye


Hi all
Ok have been given a DB with lots of E-mail address.
Have run a query to find Duplicates.
Have found Duplicates (lots of them)
Now how can I use access to get rid of the Duplicates
enters but keep the one of them
I hope I make sense.

Thanks for the help