How do I find reoccurring data in a column?

R

riotgear

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?
 
B

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));
 
Top