Rather than driving myself crazy with a nested IIF statement I want to use the Switch function. After reviewing the syntax for the function I have a question. Will a statement like Switch([Lic Cert Code] = "ABC" AND [Lic State] IS NULL, [Work State]) evaluate properly and place the current value of [Work State] in the [Lic State] field? If not what would? I have multiple cases and a nested IIF statement would get ugly. Thanks in advance!
Bill
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar