Tracing duplicated data entries

[leeek]

How to trace out duplicated data entries in MS Access?

[Beacon]

Well in Access you can just set the field properties to not allow Duplicate entries!
Let it do the work for you.

Else if you have to for some reason use as SQL statement:

SELECT DISTINCTROW First(TABLENAME.FIELDName) AS [FIELDName Field], Count(TABLENAME.FIELDName) AS NumberOfDups 
FROM TABLENAME 
GROUP BY TABLENAME.FIELDNAME 
HAVING (((Count(TABLENAME.FIELDNAME))>1));

later
b