how to locate duplicates ??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WANNABE - 28 Dec 2006 17:45 GMT

Hi, I'm sure this is so simple I will feel stupid... I can not remember how
to find records that have duplicate ID numbers. I was given a spread sheet
with 45000 records and asked to locate any records with duplicate ID's. I
remember doing something like this in access so I've imported the data into
a table and run a distinct query, which finds only 33,423 records. I keep
thinking that I should create a table of distinct IDs and use that somehow
to find the records in the original table that have duplicates but, I can't
remember how, and my mind is just not working. can someone please clue me
in as to how I can get a list of ID that have duplicates??? THANK YOU !!!

Reply to this Message

WANNABE - 28 Dec 2006 17:56 GMT

SORRY >>> NEVER MIND >> I FOUND THE QUERY >>
====================================

> Hi, I'm sure this is so simple I will feel stupid... I can not remember
> how to find records that have duplicate ID numbers. I was given a spread
[quoted text clipped - 6 lines]
> can someone please clue me in as to how I can get a list of ID that have
> duplicates??? THANK YOU !!!

Reply to this Message

Per Larsen - 28 Dec 2006 18:06 GMT

On 28.12.2006 18:45, WANNABE typed the following::

> Hi, I'm sure this is so simple I will feel stupid... I can not remember how
> to find records that have duplicate ID numbers. I was given a spread sheet
[quoted text clipped - 5 lines]
> remember how, and my mind is just not working. can someone please clue me
> in as to how I can get a list of ID that have duplicates??? THANK YOU !!!

Why not use the "Find Duplicates Query Wizard" for this, or the folowing
(you don't need the 'Count' column):

SELECT ID, Count(ID)
FROM Table
GROUP BY ID
HAVING Count(ID) > 1

PerL

Reply to this Message