&& at form procedure load CREATE CURSOR csrBillTotals (; bill_total Y , ; t1 n(20), ; t2 n(20), ; nam1 c(70))
LOCAL ldStart, ldEnd ldStart = thisform.text3.value ldEnd = thisform.text5.value SELECT nam1, SUM( innoumber),sum(t1),sum(t1) AS bill_total,t1,t2 FROM Mstr WHERE ; BETWEEN( datein, ldStart, ldEnd ) ; GROUP BY nam1 ; ORDER BY nam1 INTO CURSOR qTmpthanks