M
michelle11_5
Hi,
Using access queries only..
I have two fields, if the first field is null, then it should refer to the
second for specific words, and fill in the first field with a keyword, if the
field is not null, then leave alone. I'm getting error "The expression you
entered contains invalid syntax"
ERROR_CODE: IIf([error_code] Is Null and IIf ([error_event]like'*Manual
collection*','Manual')[error_code], (iif ([error_code] Is Null and
IIf([error_event]) like "*UTC 1970", "Never"), [error_code]))
Help? Thanks!
Using access queries only..
I have two fields, if the first field is null, then it should refer to the
second for specific words, and fill in the first field with a keyword, if the
field is not null, then leave alone. I'm getting error "The expression you
entered contains invalid syntax"
ERROR_CODE: IIf([error_code] Is Null and IIf ([error_event]like'*Manual
collection*','Manual')[error_code], (iif ([error_code] Is Null and
IIf([error_event]) like "*UTC 1970", "Never"), [error_code]))
Help? Thanks!