>GROUP BY nam,bank,sheqno,dat >>>
>>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 >> >>