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?
 
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
All Courses

From novice to tech pro — start learning today.