>I just read that again after I posted. :)
>
>Are you saying that I should store the current and past balances in every detail record? That's something I hadn't thought of. (Mulling over the possibilities...)
>
>-Michelle
>
Michelle,
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
Only direct experience is Knowledge;
Everything else is just Information.