hi all,

thanks for idea ,help

i try to run this code i got error message...

SQL: GROUP BY clause is missing or invalid

SET ENGINEBEHAVIOR 70
*| 80 | 90

LOCAL ldStart 

ldStart = DATE()
SELECT nam,bank,sheqno,dat, SUM(amount) AS bill_total FROM Mstr ;
WHERE DAT1= ldStart ;
GROUP BY sheqno ;
      ORDER BY sheqno INTO CURSOR qTmp
SELECT csrBillTotals 
ZAP
APPEND FROM DBF( [qTmp] )
go top
Thisform.grid1.refresh()

REPORT FORM  allbills preview