but i need to put myfield at this code

my table name is mstr

So does mstr have the bill details or is there a child table that has the detailed line item amounts.

myfield is billno=bill

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

datein=date

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

inname=customer name

Is inname the name of the field in your customer table? Is this field also in the Mstr table? or is it only in the Mstr table?

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

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