Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Add a total revenue field to an Access Report

Discussion in 'Information Technology' started by cpfrangi, Jul 28, 2006.

  1. cpfrangi

    cpfrangi
    Expand Collapse
    Guest

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


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

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

    cpfrangi
    Expand Collapse
    Guest

    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
    >
    >
    >
     
  5. gee664@gmail.com

    gee664@gmail.com
    Expand Collapse
    Guest

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

    cpfrangi
    Expand Collapse
    Guest

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

    "gee664@gmail.com" 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.
    >
    >
     

Share This Page