Hello Everyone,

I am trying to make edits to a report using the IIF but my problem is it is only working if it is false. So if the condition is false it passes the values but if true it just shows error on the report.

The datasource for this report is being pulled from a stored procedure in SQL...this is a ADP database.

I have tried it two different ways.
Example Format:
1) IIF([testedfield]IS Null,<[True>],<[False]>)
2) IIF([testedfiled]IS Null,<[True]>,IIF([testedfield]IS Null,<[True]>))

Thank you,
John Williams

__________________
Thank you,
John Williams

Does it matter if I am testing the false part of the condition?

=IIF([SecShipVia] Is Null, [ShipVia],[SecShipVia])

SecShipVia & ShipVia are being passed into the report by stored procedure.

Also, I am receiving a Circular Reference in the AutoCorrect Field...not for sure if that anything to do with it.

Thank you,
John Williams

Ok I found the problem. The circular reference was referring to the fact that my textbox was named the same thing as the field I was trying to pass in. So renamed the text box and it work!

Thank you,
John Williams