>I've dealt with this issue before in accounting/financial applications. It's also a major concern in OLAP apps and data-warehousing. 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. In my situation, I was trying to avoid doing million-record SUMs for simple P/L reporting.


Well our system isn't likely to run into millions of records, so summing should work for me. :)

-Michelle