Duplicates in Primary Key

[MisterMan]

Despite my best efforts, apparently my primary key has been corrupted somehow and has duplicate values. There are roughly 6500 different records in this database. Is there any way to find the duplicates without going through line by line?

Thank you!

 

[PHV]

SELECT [PK Field], Count(*) FROM yourTable
GROUP BY [PK Field] HAVING Count(*) > 1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MisterMan]

THANK YOU!