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