Jenkins
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER