Add a total revenue field to an Access Report

[cpfrangi]

I have a report of total future revenue based on Monthly Rate per
Unit*#Units*12 which gives me the yearly revenue. If the term of the
contract is 10 years...with a yearly 8% increase, how do I show a field that
gives me the total revenue over the entire 10-year period? The amount has to
appear on my Access report...so I can't use an excel spreadsheet.

Thank you....

 

[cpfrangi]

I want to show...the total revenue over the 10-year period...with the 8% per
year factored in... Thanks....I really really need help with this one...

 

[gee664]

For every value you want to show on your report, add a column in a
query. (Just like you would add a column in your spreadsheet.) Then
use the query for your report.

 

[cpfrangi]

That is what I did do...for the yearly revenue. My question was...how do I
write a formula that incorporates the rate per mo per unit * the no. of units
* 12 (for year 1)....then the rate increases by 8% year 2...and 8% year
3...etc to year 15. Then I have to add the total revenue for years 1 thru 15
for a Total Revenue for the Term of the 15-year contract. I do not know how
to write a formula in a query for Access to come up with this end number.
Thanks...