LOCAL ldStart, ldEnd, lcName lcName = UPPER( ALLTRIM( thisform.pageframe1.page1.text1.Value ) ) ldStart = thisform.pageframe1.page1.text3.value ldEnd = thisform.pageframe1.page1.text5.value SELECT inname, bill, SUM( total ) AS bill_total FROM Mstr WHERE ; UPPER( ALLTRIM( inname ) ) == lcName AND BETWEEN( datein, ldStart, ldEnd ) ; GROUP BY inname, bill ; ORDER BY inname INTO CURSOR csrBillTotals