Bill-
If you're assigning the result to the Work State field, then maybe yes. Are
you doing this in code, a query, or what? What is the business problem
you're trying to solve?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of William
Sent: Tuesday, December 10, 2013 10:40 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Proper use of Switch in Access 2010 Query
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
------------------------------------
Yahoo Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar