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