Microsoft Access Function Library: Choose()

[bbasujon]

Function: Choose()

Purpose: The Choose() function is used to select an item from a list of arguments.

Usage: Choose(index, item1, item2, …, itemn, args)

Returns: Value of the indexth argument.

Examples and Special Cases

 Choose(1, “apple”, “orange”, “banana”) = “apple”
 Choose(2, “apple”, “orange”, “banana”) = “orange”
 Choose(0, “apple”, “orange”, “banana”) = NULL
 Choose(4, “apple”, “orange”, “banana”) = NULL