Dolphin.com.bd

Office Suite Tutorial => Microsoft Office Access => Topic started by: bbasujon on August 15, 2012, 05:31:23 PM

Title: Microsoft Access Function Library: Choose()
Post by: bbasujon on August 15, 2012, 05:31:23 PM
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