SELECT nam1, SUM( innoumber),sum(t1),sum(t1) AS bill_total,t1,t2 FROM Mstr WHERE ; BETWEEN( datein, ldStart, ldEnd ) ; GROUP BY nam1,t1,t2 ; ORDER BY nam1 INTO CURSOR qTmp>hi all,
>&& 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 qTmp >>thanks