how to locate duplicates ??

[WANNABE]

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 !!!

 

[WANNABE]

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

 

[Per Larsen]

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 !!!

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