>hi all,
>
>i need help to sum many fields via this code under..
>i get error message SQL: GROUP BY clause is invalid
>
>
>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
What is the type of field NAM1? I think you can't group by memo fields.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)