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