IIf statement with two or more choices

message from =?Utf-8?B?a3dfdWg5Nw==?= on 7 May 2004
Is there a similar function to the IIf function for more then two options or do I have to do some complicated programming to get my results.

Here is my table and values
[STATUS]
C
R
M
H

This would work great for two choices,
=IIf([STATUS]="C","CLOSED","READY")

but, as you can see I have four choices.

Thanks In Advance
 
=?Utf-8?B?a3dfdWg5N0B5YWhvby5jb20=?= replied to =?Utf-8?B?a3dfdWg5Nw==?= on 7 May 2004
Thanks To All

Read through some of the posts and found my answer.

Nested IIf statements if you want more than two options

Thanks Again
Ken
 
Douglas J. Steele replied to =?Utf-8?B?a3dfdWg5N0B5YWhvby5jb20=?= on 7 May 2004
=Switch([Status] = "C", "Closed", _
[Status] = "R", "Ready", _
[Status] = "M", "Maybe", _
[Status] = "H", "Help")
 

Archived message: IIf statement with two or more choices (Microsoft Access Forms)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.