>Here it is:
>
>SELECT temp.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.