How do I create a waterfall amortization schedule in Access?

[Guest]

I know its not desirable to store calculated values for amortization, so how
do I calcluate and report? In Access 2003, I have a table with invoice
information, and I need the revenue (invoice amount) to be amortized between
a start and end date (included in the table), and at any given month total
all invoice with amortization for the month.

 

[Arvin Meyer [MVP]]

Those calculations can be done in a report. Depending upon the amount of
data that needs to be processed, you may want to build temporary tables to
store data results while running the report, deleting and refreshing that
data as necessary when new reports are created. That is very similar to
using an OLAP cube to slice and store the data temporarily.