I was able to get the first one figured out with your help where I checked for 3 values and if they're null then put X
This says that no occurrence was detected.
Now I need to check for an occurrence in any of those 3 fields so I need to use OR but can't seem to get this to work. I get the error "the expression you entered is missing a closing parenthesis, bracket, or vertical bar".
When using this code I get the error "wrong number of arguments".
Any help is appreciated, thanks.
NoPatOcc: IIF (IsNull([P0_Count]), IIf(IsNull([P1_Count]), IIf(IsNull([P2_Count]), "X", " ")))
This says that no occurrence was detected.
Now I need to check for an occurrence in any of those 3 fields so I need to use OR but can't seem to get this to work. I get the error "the expression you entered is missing a closing parenthesis, bracket, or vertical bar".
YesPatOcc:IIf(Not IsNull([P0_Count]) Or IIf(Not IsNull([P1_Count]) Or IIf(Not IsNull([P1_Count]), "X", "")
When using this code I get the error "wrong number of arguments".
YesPatOcc:IIf(Not IsNull([P0_Count]) Or IIf(Not IsNull([P1_Count]) Or IIf(Not IsNull([P2_Count]), "X", "")))
Any help is appreciated, thanks.