kgittinger
asked on
Access If else if syntax problem
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.
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.
[over60]
If debits(90)>=BAL
Then If (BAL-Over30)>0
then Over60=(BAL-Over30)
else Over60=0
Else over60=(Debits(90)-over30)
Endif
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]))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
did you also try did the shorter version?
ASKER
Both produced the same results. Thanks you again for all of your help.
ASKER