thank you very much.
yes, it works

>>hi all,
>>any idea,help
>>this code work fine without field name is tra (memo type),
>>i got error message GROUP BY clause is missing or invalid
>>
>>

>>LOCAL ldStart
>>ldStart = thisform.text1.value
>>SELECT nam,amount,bank,sheqno,dat,tra,  SUM(amount) AS bill_total FROM Mstr ;
>>WHERE dat= ldStart ;
>>GROUP BY nam,amount,bank,sheqno,dat,tra ;
>>ORDER BY sheqno INTO CURSOR qTmp
>>

>>thanks
>
>
>You can not include memo field. If you want to use memo field you would need to run with SET ENGINEBEHAVIOR 70.
>
>See Re: GROUP BY clause is invalid Thread #1245947 Message #1245974