hi,
thank you very much,

but i need to put myfield at this code .

my table name is mstr
myfield is
billno=bill
datein=date
inname=customer name
total=this is what i want to sum for one customer and for all customers.
between 2 dates.

i don't have customer no. at mytable.

how i can insert the result at mygrid.

thanks.
best regards
m.qasem