What is the equivalent of Select Case in Access SQL?
Consider the Switch Function as an alternative to multiple IIf() expressions. It will return the value from the first expression/value pair where the expression evaluates as True, and ignore any remaining pairs. The concept is similar to the SELECT … CASE approach you referenced but which is not available in Access SQL. If you want … Read more