Solved

Find duplicates in an Access table

Posted on 2014-02-19
2
319 Views
Last Modified: 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.
0
Comment
Question by:dbfromnewjersey
2 Comments
 
LVL 20

Accepted Solution

by:
clarkscott earned 500 total points
ID: 39869700
Use the Access query wizard "Find duplicates Query Wizard".
Select your table and the fields that you are checking for dups.

Scott C
0
 

Author Comment

by:dbfromnewjersey
ID: 39870025
Thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now