Access - The Switch function

The Switch function allows you to evaluate a seriesof expressions and return a Variant value corresponding value for the first expression in the list, if condition is


Switch ( expression-1, value-1, expression-2, value-2, ... expression-n, value-n )


Switch ( Customer_ID=1, "John", Customer_ID=2, "Smith", Customer_ID=3, "Thomas")
  • If Customer_ID is equal to 1, the value returned will be "John"
  • If Customer_ID is equal to 3, the value returned will be "Thomas"
Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Access - The Switch function », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (