Hi Everyone!
I hoping someone can provide some info as to a solution to this problem.
I need to add two previous record fields together in a query. I have attached a picture to help illustrate.
The "StudyYears" filed is the primary key of the table the data is being pulled from. The zero's are placeholders for the sum of the previous record's data.
RunningBalance is calculated as follows:
Bal is calculated as follows:
Can anyone recommend how to go about adding the two together as in the picture?
Is there a way to do this relatively fast, as well as keeping the query updateable?
Thank you for all your help.
I hoping someone can provide some info as to a solution to this problem.
I need to add two previous record fields together in a query. I have attached a picture to help illustrate.
The "StudyYears" filed is the primary key of the table the data is being pulled from. The zero's are placeholders for the sum of the previous record's data.
RunningBalance is calculated as follows:
Code:
RunningBalance: IIf([a].[StudyYears]=[ReserveParameters]![StartingBalanceYear],CCur([ReserveParameters]![StartingBalance]),0)Bal is calculated as follows:
Code:
Bal: [AnnualContribution]+[InterestIncome]+[Inflation_Adjusted_Expenditures]Can anyone recommend how to go about adding the two together as in the picture?
Is there a way to do this relatively fast, as well as keeping the query updateable?
Thank you for all your help.
