General information
Category:
Reports & Report designer
It looks good to me too. Yes, it can be done.
I presume that you've checked that all field names/variables are correctly spelled and that the table is open and not at eof.
Do you have an = before this and something coded on the left side of the =? I think there needs to be
good luck,
JimN
>I am using the IIF() to get a value for a field in a report and need to nest the IIF(). Can this be done?
>The expression I am using for a field in a report goes something like this:
>
>IIF(hank.pla_level = '1st', IIF(HANK.PLA_WITH = 'Ideal',ROUND(HANK.AMOUNT *.3,2), ROUND(hank.amount*.275,2)), ROUND(hank.amount*.5,2))
>
>It looks good to me, however my logic may have a flaw I cannot find or nesting this type of expression may not be valid... I keep getting a 'syntax error'. I am sure there is an easier way to accomplish my goal, however, I would really like to know if nesting the IIF is possible and what I could be doing wrong? Any ideas would be great!
>
>Also, I am new at this please be kind :)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only