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