I'm using the IIF function with the OR statement in a query. The issue I'm having is that the expression will return the proper result if the true statement is true but is giving the #Error instead of the if false value?
The expression I'm using is:
IIf([Outage Due(Raw)]="26" Or [2nd Due]="26",[PMRQ Title],"N/A")
Here is selected screenshot of the result using the above expression if that helps anyone.
https://docs.google.com/document/d/1...it?usp=sharing
I'm sure there is an easy reason but I can't seem to figure it out. I would appreciate any insight anyone might have. Thanks.