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