Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

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

Results 1 to 2 of 2
Share This Thread →
  1. #1
    jrub is offline Registered User
    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
    meratigoerr's Avatar
    meratigoerr is offline Contributing User
    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 01:59 PM.

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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, 07:00 PM
  2. Replies: 0
    Last Post: October 14th, 2010, 03:00 PM
  3. Calculation based on time values
    By bpinto in forum Microsoft Access Help
    Replies: 2
    Last Post: June 1st, 2009, 03: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, 11:47 AM
  5. Major Challenge - Update a table based on calculation
    By chimp in forum Microsoft Access Help
    Replies: 5
    Last Post: November 17th, 2004, 05:53 AM

ASP Free Advertisers and Affiliates