hi,
thank you very much, it works

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