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 wrote:
> 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....

Do you want to show a final result, a daily, monthly or yearly result
the current accumulated amount ???

--
Joseph Meehan

Dia duit

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...

"Joseph Meehan" wrote:

> cpfrangi wrote:
> > 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....
>
> Do you want to show a final result, a daily, monthly or yearly result
> the current accumulated amount ???
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>

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.

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...

"(E-Mail Removed)" wrote:

> 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.
>
>