I don't understand why it didn't work as you wrote, since SET ENGINEBEHAVIOR 70 allows you to run wrong (old style) queries. See my FAQ for eliminating duplicates, I used SET ENGINEBEHAVIOR 70 there.

Though in your case it may be better to add these fields to GROUP BY.

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