troubleshooting Question

Access 2007 - query syntax

Avatar of Jegajothy vythilingam
Jegajothy vythilingamFlag for United States of America asked on
Microsoft OfficeWeb BrowsersSQL
4 Comments1 Solution224 ViewsLast Modified:
My OS is windows 7 and I use Access 2007.  I have a database which has duplicates and I created a find duplicates from the query wizard.  The result was all emails that were more than 1.  I now want to delete those that are more than 1,  but when I try to run the same query using the Delete feature, looks like it is deleting ALL the emails in the Table.  The query syntax that I created is in the code section.  Thank u
SELECT First(Contacts.[E-mail Address]) AS [E-mail Address Field], Count(Contacts.[E-mail Address]) AS NumberOfDups
FROM Contacts
GROUP BY Contacts.[E-mail Address]
HAVING (((Count(Contacts.[E-mail Address]))>1));
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros