Duplicates

[jen]

I've got a table with some few thousand email addresses.
I've done a query to find duplicates and there are THOUSANDS,
Using the result of the query I started to delete the duplicates manually.
Some most are duplicated 4-5 times so are bunched together and easy to do.
But it's going to take me hours and hours.
Is there a way to run another query to append or delete or whatever all the
duplicates but leaving the one (of each) behind?
The emial address colum is the only one in this table so I don't need to
worry about other details
Thank you

 

[Brendan Reynolds]

If the e-mail address is the only column in the table, the simplest solution
might be to create a make-table query that groups by the e-mail address. For
example ...

SELECT OldTable.EmailAddress INTO NewTable
FROM OldTable
GROUP BY OldTable.EmailAddress;

Then delete the old table (make a back up first, just in case) and rename
the new table same as the old one.

 

[jen]

Thanks for you time (and patience)
I did as you said, but I got a new table that is just like the old table.
With all the duplicates. So I'm missing something for sure.

 

[Brendan Reynolds]

If you post your SQL, we might be able to see what the problem is.