Eliminating Duplicates

[bjm027]

Hello,

I am combinding many email addresses from several different tables. In some cases there are duplicate email addresses. What would be the best approach to take that final product of just the emails addresses and eliminating all the duplicates.

If you need more information, just let me know.

Any help appreciated. Thanks in advance.

 

[dhookom]

Make a totals query that groups by email address.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[bjm027]

I just did it in a generic way. I put all the email addresses I have into one table, then ran a query that was SELECT DISTINCT of those email address and it eliminated the duplicates. It works for now. I figured this was alright because all of our sites and databases are going to be ripped out and redone here shortly so that we can avoid problems like this. A quick fix for now...

Thanks though

 

[JonFer]

That is not just a quick fix - that is a good way to remove duplicates if you are not calculating any aggregates for the records. Select DISTINCT removes duplicates while GROUP BY is normally used to produce subtotals or counts at a certain level of detail. If you don't include any aggregate functions with the GROUP BY, it produces the same result as Select DISTINCT.