Delete duplicate company names

[access2010]

The charity that I volunteer at has a web site through which they receive donations
Most of the COMPANY names that they receive through their website are JUNK.
I would like to help them have a system to delete duplicate company names,
A = first programmatically delete all company names that are GOOGLE and this will remove about 60% of their spam
B = next group all Duplicate Company names, which will be removed manually
Could I please receive a suggestion on how I can help them with this problem?
Thank you

 

[namliam]

Well why remove duplicates? They appear there for a reason, may be better to only query them as unique addresses instead of trying to clean up a mess....

This would be something like:

SELECT unwanted_Emails.Company
     , Min(unwanted_Emails.ID) AS MinVanID
     , Count(unwanted_Emails.Company) AS AantalVanCompany
FROM unwanted_Emails
GROUP BY unwanted_Emails.Company

Creating a delete from here should be quite easy as well, however I dont think that would be a good thing.

 

[access2010]

Thank you for your suggestion.
The organization that I volunteer at received for the month of October approximately the following junk emails,
3,700 Companies with the name Google
1,745 Companies with a Hexadecimal mix
Or 5,445.00 junk emails from their website, which I presume were sent to get into their database to steal donor credit card information
They would like to,
A = delete all company names that are GOOGLE
B = group all Duplicate Company names, which will be removed manually
Would you please suggest how they can fix this spam problem?
Your idea will be appreciated

 

[Gasman]

I would start with something like this

SELECT DISTINCT unwanted_Emails.Company
FROM unwanted_Emails
WHERE (((unwanted_Emails.Company) Not Like "*Google*"));

The key here being DISTINCT keyword which I entered into the SQL view manually. I then added the NOT LIKE *GOOGLE* to remove google addresses.

If you comverted this to a make table query, you would have unique names with no google addresses. Weed out the rest from there.

HTH

 

[access2010]

We are getting there and thank you for your suggestion.
Fixed = 3,700 Companies with the name Google can now be deleted as a group

How would you suggest that we group and delete all of the remaining DUPLICATE companies?
1,745 Companies with a Hexadecimal mix

Your idea will be appreciated

 

[namliam]

The query I gave above should take care of any duplicate addresses?

 

[access2010]

Thank you for your suggestions.