Find Duplicates

[TheScullster]

Hi all

Probably straight forward, but I'm struggling with this one.
How do I find records that have duplicate entries in a field?
I understand how to get rid of duplicates, copy table structure-make primary
key-run append query, but I want to know which records are being dropped!
Can I make a select query to highlight duplicates?

TIA

Phil

 

[Wolfgang Kais]

Hello Phil.

Hi all

Probably straight forward, but I'm struggling with this one.
How do I find records that have duplicate entries in a field?
I understand how to get rid of duplicates, copy table structure-make
primary key-run append query, but I want to know which records are
being dropped! Can I make a select query to highlight duplicates?

There is a wizard that can build a query for you:
In the database window select "Queries" and then click "New".
In the "New Query" window, select the wizard and click "Ok".
The query that the wizard bild for you will display a sorted datasheet
that displays the records with duplicate entries together, so that you
can decide to edit or delete some of the records.