I know this is likely a simple issue that i'm overlooking but i'm not getting the results i'm expecting to see.
CoverageStatus: IIf([employee]="X" or "Y" and IIf([Notes] Is Null,"pending",""))
The intent is to use this calculated result to reference on a report for conditional formatting.
I'm sure i'm reading too deep into and i'm pretty sure i have the correct syntax. Someone help.
Also if it at all helps, I have employee id and employee concatenated field with the name so i can use the employee name or employee id for the employee portion of this syntax, in the above example, i'm using the employee name.
CoverageStatus: IIf([employee]="X" or "Y" and IIf([Notes] Is Null,"pending",""))
The intent is to use this calculated result to reference on a report for conditional formatting.
I'm sure i'm reading too deep into and i'm pretty sure i have the correct syntax. Someone help.
Also if it at all helps, I have employee id and employee concatenated field with the name so i can use the employee name or employee id for the employee portion of this syntax, in the above example, i'm using the employee name.