Repeating Record Search

[montejr]

Hi all,
I have a parcel table containg pin numbers. I need this field (pin) to be the primary key. I can't because it has duplicate values. Is there a way that I can search for repeating values(pin's) in Access?

Thanks,
Michael

 

[RobertT687]

Try a query like this:
SELECT Table1.PinNbr, Count(Table1.PinNbr) AS CountOfPinNbr
FROM Table1
GROUP BY Table1.PinNbr
HAVING (((Count(Table1.PinNbr))>1));