How do I find reoccurring data in a column?

[Guest]

I'm looking to set a column as a Primary key, but it keeps telling me that I
have reoccurring data, which I can't find? Is there a way to search for it?

 

[Ed Robichaud]

Access has query wizard specifically to find duplicates; check it out.
-Ed

 

[Brendan Reynolds]

Replace 'tblTest' with the name of your table, and 'TestCur1' with the name
of the field in which you want to find duplicate values.

SELECT tblTest.TestCur1, Count(tblTest.TestCur1) AS CountOfTestCur1
FROM tblTest
GROUP BY tblTest.TestCur1
HAVING (((Count(tblTest.TestCur1))>1));