Does this find duplicates on the first name?

[xandre]

I'm trying to figure out what this query is basing its duplicate-finding on. It looks like the first name..

Can someone please explain it to me?

Thanks..

SELECT DISTINCTROW First(TblforRptDistSchool.ContactFirst) AS [ContactFirst Field], First(TblforRptDistSchool.ContactLast) AS [ContactLast Field], Count(TblforRptDistSchool.ContactFirst) AS NumberOfDups
FROM TblforRptDistSchool
GROUP BY TblforRptDistSchool.ContactFirst, TblforRptDistSchool.ContactLast
HAVING (((Count(TblforRptDistSchool.ContactFirst))>1) AND ((Count(TblforRptDistSchool.ContactLast))>1));

 

[Maquis]

It's based on ContactFirst and ContactLast. Both have to match in order for a dup to appear.

...HAVING (((Count(TblforRptDistSchool.ContactFirst))>1) AND ((Count(TblforRptDistSchool.ContactLast))>1));
Maq B-)
<insert witty signature here>

 

[xandre]

Ah.. I see now. Thank you