By using this website, you agree to our Terms of Use (click here)
Hi Tim
Here is my scenario
i want to pull information on the report designer using the iff statement as follow
=IIf([APAdjust.LMTransactionCode]='80','Grant','0') and it works fine and i have a range from 80-89 and all those should print Grant if used on the transaction. On the same column IIf([APAdjust.LMTransactionCode]='60','Loan','0') and this range is 60-69 and all those print Loan if used on the transaction but if i add this then it doesnt work .
Please assit
You have to nest your IIFs. =IIf([APAdjust.LMTransactionCode]='80','Grant',IIF([APAdjust.LMTransactionCode]='60','Loan','0')) Not sure if I have that nested exactly right or not but it will get you close.
Thank you KimM
It worked.
Online Members
