LOCAL ldStart, ldEnd ldStart = thisform.pageframe1.page1.text3.value ldEnd = thisform.pageframe1.page1.text5.value SELECT inname, billno, SUM( total ) AS bill_total FROM Mstr WHERE ; BETWEEN( datein, ldStart, ldEnd ) ; GROUP BY inname, billno ; ORDER BY inname INTO CURSOR qTmp SELECT csrBillTotals ZAP APPEND FROM DBF( [qTmp] ) Thisform.pageframe1.page1.grid1.refresh()2.how i can see the result via grid
CREATE CURSOR csrBillTotals (; inname C( 30 ), ; billno I, ; bill_total Y )Set the grid's RecordSource to csrBillTotals in the form designer