sum of a field filtered by date

[Ramesh]

HI

I have a table with commitments of customers on how much they will pay on
what date. The fields are customer id, date and amount.

Need to make a query to list out customer id, total payable till current
date. I tried using sum function in total row in design grid, but it gives
me some wierd result. other functions like avg, max and min work fine.

also where can i specify that records with future dates are not to be
included in the total?

Thanks for any help

Ramesh