Find duplicates in an Access table
Posted on 2014-02-19
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.