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