Hi Everyone,
I have a dsum to summ all previous values. It's being used in a continuous form with only max 30 record.
If it's 2013, I want the first record to be 1000, and the rest of the following records be the a running sum.
I get a #Type! error in the first record and a #Error in the remaining records.
I have a dsum to summ all previous values. It's being used in a continuous form with only max 30 record.
If it's 2013, I want the first record to be 1000, and the rest of the following records be the a running sum.
I get a #Type! error in the first record and a #Error in the remaining records.
Code:
=IIf([StudyYears]="2013",[RunningBalance]="1000",DSum("[RunningBalance]","StudyYears","[StudyYears] <= Forms![FundingPlan]![StudyYears]")