>You should store the current balance in each record at the time the record is created. If the file is indexed datewise, you should be able to get the balance as of any past date at any time later.
>
>HTH
>
>Alhad

I like that idea, but I got two others yelling "No!" at me. So far it's the best I've seen. I just don't see how I can calculate the past balances. The current, yes, because that's just a sum of the trips and payments. But the past balances change whenever you apply a payment.

-Michelle