Please help with troubleshooting my expression.
I have been asked to write the following statement and am having syntax problems:
The first segement below is my instruction and the second is what I have entered in the expression builder.
Then If (BAL-Over30)>0
60To90DayDebits:Sum(IIf([Query1]![SumOf90To120DayDebits]>=[Dbo_Accounts!Balance], IIf([Dbo_Accounts!Balance]-[Query1]![SumOf30To60DayDebits]>0, [Dbo_Accounts!Balance] - [Query1]![SumOf30To60DayDebits]), 0),[Query1]![SumOf60To90DayDebits]-[Query1]![SumOf30To60DayDebits]))