Anonymous

SELECT First(RCDDA.na_account_number) AS [na_account_number Field], Count(RCDDA.na_account_number) AS NumberOfDups
FROM RCDDA
GROUP BY RCDDA.na_account_number
HAVING (((Count(RCDDA.na_account_number))>1));