>Jim,
>
>The field names are generic, not the actual name. The SELECT statement seemed to be over counting the number of records. I was counting 20 records in the data session, but the utility was giving me 55 records as a count.
>
>
>
>
>>>Here it is:
>>>
>>>SELECT mnemonic, ata, name, class, type, status, CNT(*) FROM temp ;
>>>INTO TABLE assignee_temp ;
>>>WHERE group = gcGroup AND dept = gcDept ;
>>>AND BETWEEN(assign_date,gdStartDate,gdEndDate) ;
>>>GROUP BY 1,2,3
>>>
>>>
>>>>What is the SQL statement you have tried that does not work?
>>>>
>>
>>Jeff,
>>
>>The first thing I would try is renaming the field named group, it is a keyword in the SQL syntax and could be confusing VFP.

Perry,

Why not simply rely on _TALLY? It should give you the right count in this case.

José