Find duplicates in an Access table

I have an Access table that currently does not have a primary key. The table has many fields.

There should be only one record for a given date, account number and location but apparently in some instances, there is more than one because when I try to create a primary key using those 3 fields, I get a duplicate values error message.

I need a query that will retrieve all records where there is more than one record for a given date, account number and location. Thank you.
dbfromnewjerseyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
clarkscottConnect With a Mentor Commented:
Use the Access query wizard "Find duplicates Query Wizard".
Select your table and the fields that you are checking for dups.

Scott C
0
 
dbfromnewjerseyAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.