Solved

Find duplicates in an Access table

Posted on 2014-02-19
2
323 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

785 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