Thanks Garrett.

Yeah, it's just simple data warehousing concepts....

>>>Because if you delete a detail line somewhere, you have to recompute all the
>>>balances after it, for example....
>>The simplist way that I have found to address it is to create a summary table
>>of running balances per month, quarter, year. Every single entry updates (or
>>creates and updates) the summary table entry applicable.
>
>Good idea: that handles the problem, and you can always recreate it fresh by running that million-record SUM(), if you suspect corruption....