Evaluate a list of expressions and return a value corresponding to the first expression that is TRUE.
Syntax Switch ( expr1, value1, expr2, value2, … expr_n, value_n ) Key expr1,expr2… The expressions to evaluate. value1,value2 … A list of values
The switch() function can be used in VBA or in an SQL query.
Dim strDemo as String
strDemo = Switch (CountryID = 1, "USA", CountryID = 2, "Canada", CountryID > 2, "other" )
“The test of a good teacher is not how many questions he can ask his pupils that they will answer readily, but how many questions he inspires them to ask him which he finds it hard to answer” ~ Alice Wellington Rollins
If Then Else - If-Then-Else
Case - If Then Else
Nz - Detect a NULL value