hi,
thank you very much,
it works.

1.how i can get all customers.
2.how i can see the result via grid

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, billno, SUM( total ) AS bill_total FROM Mstr WHERE ;
  UPPER( ALLTRIM( inname ) ) == lcName AND BETWEEN( datein, ldStart, ldEnd ) ;
  GROUP BY inname, billno ;
  ORDER BY inname INTO CURSOR csrBillTotals
  brow&&

thanks
best regards.
m.qasem