>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

I think you're going to want to add an Order By Clause. And also as a side note I would name your CNT variable.