how to locate duplicates ??

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


.