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 E. Chrzanowski
Programmer/Analyst
Saturn (Solutions) Inc.