>>Hi,
>>Can someone help me with the SQL to find all duplicates in a field?
>>Thanks,
>>Allen
>

select KeyFld, count(*) as CntDups from TestDups group by 1 ;
>     having CntDups > 1 ;
>     into cursor curDupes
>

Thanks for the quick reply. I lost count on how many times you've helped me but it's always so appriciated.
Allen