Add Previous Record to Current Record

[jrub]

Hi Everyone,

From the image below, I managed to get calculated filed data summed and added to the next row. What I can't get done, is adding the previous "RunningBalance2" data to the next row as well.

When I included the field "RunningBalance2" to the query statement, Access won't even let me run it without asking me for the input for it......any ideas anyone?

My working statement is:

RunningBalance2: CCur(Nz((SELECT Sum(T1.AnnualContribution+T1.InterestIncome+T1.Inflation_Adjusted_Expenditures) FROM FP_Default As T1 WHERE T1.StudyYears<FP_Default.[StudyYears]),[ReserveParameters]![StartingBalance]))

 

[Jasonxyz]

If I understand correctly you want a calculated value to run with data based on its previous self? So RunningBalance2 row 1 is the basis for RunningBalance2 row 2?

 

[jrub]

Yes, exactly that.

Any ideas?