Converting value to text in query

P

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.
 
R

Rick Brandt

pat said:
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.
Click to expand...

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