Much better. I didn't want to throw in the "having" because I was away from VFP.

>

>SELECT COUNT(Sin) as DupCnt, Sin + DTOS(Add_date) + Add_time AS pKey ;
>  FROM SheenaTable ;
>  GROUP BY pKey;
>  INTO CURSOR cDuplicates ;
>  HAVING DupCnt > 1
>

>
>
>
>>>Hi:
>>>
>>>I want to list duplicate records that are violating my primary key of sin+dtos(add_date) + add_time form my employ table.
>>
>>Off the top of my head
>>

>>SELECT cnt(sin) as dupcnt, sin+dtos(add_date) + add_time as pkey ;
>>  FROM sheenatable ;
>>  ORDER BY 1 DESC ;
>>  GROUP by 2 ;
>>  INTO CURSOR cDuplicates
>>

>>
>>Then look for any items with dupcnt > 1