troubleshooting Question

Find duplicate records in Access table

Avatar of valmatic
valmaticFlag for United States of America asked on
Microsoft AccessSQL
17 Comments1 Solution723 ViewsLast Modified:
Hi.  I have a database that stores information about equipment, maintenance and costing for my business.  Users entered duplicate maintenance records for various equipment by mistake and now want to clean it up.  Maintenance table consists of assetID, MaintID, MaintDescr, ReqDate, DueDate, etc...   I need to find any records where both the assetID and MaintDescr fields are the same.  I tried the built in duplicate query function in access2010 and it returned a lot of false positives.  I tried manipulating the SQL command with my limited knowledge of SQL and had no luck.  Any ideas how I could find al of these duplicate records?  thanks
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 17 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 17 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