Last updated: August 25, 2026.
The Access Choose function selects one value from a list using a 1-based numeric index.
Syntax
Choose(index, choice-1 [, choice-2, ... [, choice-n]])| Argument | Description |
|---|---|
index | Position of the value to return, starting with 1. |
choice | A value or expression available at that position. |
Examples
Choose(2, "Small", "Medium", "Large") ' Medium
QuarterName: Choose([QuarterNo], "Q1", "Q2", "Q3", "Q4")
PriorityLabel: Choose([Priority], "Low", "Normal", "High")If the index is outside the available range, Choose returns Null. Validate the index or wrap the expression with Nz() when a fallback is needed. All choice expressions may be evaluated, so avoid using Choose to hide an expression that could raise an error.
Turning Access queries into a web application? See the PHPRunner approach to replacing Access applications.
