Converting value to text in query

[pat]

Please help. Trying to covert a numerical statement to
text in a query:
Field name is [BA] Field stores numerical values. Need to
covert to test in query as follows:
1=Open
2=Complete
3=N/A
Unable to determine correct expression to use.

 

[Rick Brandt]

Please help. Trying to covert a numerical statement to
text in a query:
Field name is [BA] Field stores numerical values. Need to
covert to test in query as follows:
1=Open
2=Complete
3=N/A
Unable to determine correct expression to use.

TextOutput: Choose([BA], "Open", "Complete", "N/A")

 

[Lynn Trapp]

IIF([BA] = 1, "Open",IIF([BA] = 2,"Complete","N/A"))