1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Dec 2012
    Rep Power

    Calculation of Interest Based on Running Sum = #Error = I'm Going Crazy

    Many thanks for reading. I'm going crazy trying to understand this...

    Can anyone help sort out my efforts to calculate an interest value (a straight forward calculation), based on a running sum value? I would like the running sum to detect if it's the first year, and default to a specified value, and start the running sum afterwards.

    I've managed to get to the point where I can get the first value, and the interest is calculated, but all other records report the error: #Error and I'm not sure why, any help?

    My running balance query formula is the following:

    RunningBalance: IIf([StudyYears]=[ReserveParameters]![StartingBalanceYear],[ReserveParameters]![StartingBalance],Val(Nz((DSum("[Interest]+[Contribution]+[Inflation_Adjusted_Expenditures]","Query1","StudyYears <=" & [StudyYears])),0)))
    and my Interest formula is the following:

    Interest: ([ReserveParameters]![InvestmentRate]*([RunningBalance]-[Inflation_Adjusted_Expenditures]/2+[AnnualContribution]/2))
  2. #2
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    South Jersey
    Rep Power
    What type of datafield is [StudyYears] ? and when you say "You found the first year" do you mean the lowest year (as in oldest)?
    Last edited by meratigoerr; February 20th, 2013 at 02:59 PM.

Similar Threads

  1. Exclusive: Interest in Eurohypo loan sale running high
    By RSS_News_User in forum Business News
    Replies: 0
    Last Post: April 3rd, 2012, 08:00 PM
  2. Replies: 0
    Last Post: October 14th, 2010, 04:00 PM
  3. Calculation based on time values
    By bpinto in forum Microsoft Access Help
    Replies: 2
    Last Post: June 1st, 2009, 04:25 PM
  4. 30 second error check because I'm going crazy lol
    By TheNextNobuo in forum ASP Development
    Replies: 5
    Last Post: July 8th, 2005, 12:47 PM
  5. Major Challenge - Update a table based on calculation
    By chimp in forum Microsoft Access Help
    Replies: 5
    Last Post: November 17th, 2004, 06:53 AM

IMN logo majestic logo threadwatch logo seochat tools logo