You have to include all none-aggregate fields from the SELECT field list into the GROUP BY clause. See Re: Change in SQL commands! Thread #941771 Message #941774 for more detauls.

GROUP BY nam,bank,sheqno,dat

>
>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
>
>