thanks so much,
it works.
>

>SELECT nam1, SUM( innoumber),sum(t1),sum(t1) AS bill_total,t1,t2 FROM Mstr WHERE ;
>  BETWEEN( datein, ldStart, ldEnd ) ;
>  GROUP BY  nam1,t1,t2 ;
>   ORDER BY nam1 INTO CURSOR qTmp

>>hi all,
>>
>>i need help to sum many fields via this code under..
>>i get error message SQL: GROUP BY clause is invalid
>>

>>&& at form procedure load
>>CREATE CURSOR csrBillTotals (;
>> bill_total Y , ;
>> t1 n(20), ;
>> t2 n(20), ;
>>nam1 c(70))
>>

>>
>>

>>LOCAL ldStart, ldEnd
>>ldStart = thisform.text3.value
>>ldEnd = thisform.text5.value
>>
>>SELECT nam1, SUM( innoumber),sum(t1),sum(t1) AS bill_total,t1,t2 FROM Mstr WHERE ;
>>  BETWEEN( datein, ldStart, ldEnd ) ;
>>  GROUP BY  nam1 ;
>>   ORDER BY nam1 INTO CURSOR qTmp
>>

>>thanks