Last updated: August 26, 2026.
The Switch function evaluates condition/value pairs and returns the value belonging to the first true condition.
Syntax
Switch(expr1, value1 [, expr2, value2 ...])| Argument | Description |
|---|---|
expr | Condition evaluated as True or False |
value | Result associated with the preceding condition |
Examples
Grade: Switch([Score] >= 90, "A", [Score] >= 80, "B", [Score] >= 70, "C", True, "Below C")
Band: Switch([Amount] < 100, "Small", [Amount] < 1000, "Medium", True, "Large")Place the most specific conditions first and add a final True pair when a default result is needed. Switch may evaluate expressions beyond the returned pair, so avoid unsafe result expressions.
See Microsoft’s Access function reference for related expression functions.
