hi,
thank you,

yes, mstr have the bill details .

myfield is billno=bill

Are you saying that what I am calling bill_no is called bill in your table?yes

datein=date

Is the name of the field in the Mstr table called datein? yes
And what variable names do your start date and end date have on the form where you are gathering your query parameters?

select * from mstr;
   where UPPER(inname) = UPPER(TRIM;
     (thisform.pageframe1.page1.text1.Value));
     and nam1 =thisform.pageframe1.page1.text4.Value and;
     datein>=thisform.pageframe1.page1.text3.value .and.;
     datein<=thisform.pageframe1.page1.text5.value;
  into cursor TempReport
report FORM mstr22 preview

inname=customer name

Is inname the name of the field in your customer table? Is this field also in the Mstr table? yes in bothe

total=this is what i want to sum for one customer and for all customers. between 2 dates.&&yes

Is total the name of the field in the Mstr table that contains the amount?yes

thanks,

best regards
m.qasem