LOCAL ldStart ldStart = thisform.text1.value SELECT nam,amount,bank,sheqno,dat, SUM(amount) AS bill_total FROM Mstr ; WHERE dat= ldStart ; GROUP BY nam,amount,bank,sheqno,dat ; ORDER BY sheqno INTO CURSOR qTmp REPORT FORM report3 preview