iif is null statement with qualifiers

[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!

 

[KARL DEWEY]

Your IIF statement does not match your verbage but here is a guess --
ERROR_CODE: IIf([error_code] Is Null And (([error_event] like "*Manual*") Or
([error_event] like "*UTC 1970")), "Never", [error_code])

 

[michelle11_5]

Thanks for the quick reply!

Actually, if it is null and says anything manual* it needs to return Manual
and if it is null and says anything *UTC 1970 then return Never, but if it
already has a code entered, leave the code as is.

Your IIF statement does not match your verbage but here is a guess --
ERROR_CODE: IIf([error_code] Is Null And (([error_event] like "*Manual*") Or
([error_event] like "*UTC 1970")), "Never", [error_code])

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!

 

[KARL DEWEY]

Try this --
ERROR_CODE: IIf([error_code] Is Null And [error_event] like "*Manual*",
"Manual", IIF([error_code] Is Null And [error_event] like "*UTC 1970",
"Never", [error_code]))

Thanks for the quick reply!

Actually, if it is null and says anything manual* it needs to return Manual
and if it is null and says anything *UTC 1970 then return Never, but if it
already has a code entered, leave the code as is.

Your IIF statement does not match your verbage but here is a guess --
ERROR_CODE: IIf([error_code] Is Null And (([error_event] like "*Manual*") Or
([error_event] like "*UTC 1970")), "Never", [error_code])

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!

 

[michelle11_5]

Like a charm... Thank you!

Try this --
ERROR_CODE: IIf([error_code] Is Null And [error_event] like "*Manual*",
"Manual", IIF([error_code] Is Null And [error_event] like "*UTC 1970",
"Never", [error_code]))

Thanks for the quick reply!

Actually, if it is null and says anything manual* it needs to return Manual
and if it is null and says anything *UTC 1970 then return Never, but if it
already has a code entered, leave the code as is.

Your IIF statement does not match your verbage but here is a guess --
ERROR_CODE: IIf([error_code] Is Null And (([error_event] like "*Manual*") Or
([error_event] like "*UTC 1970")), "Never", [error_code])


:

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!