Convering Numerics into Words

[dpwsmw]

I have a report and in the report I call data from a query that has a field called choice, 1 = yes 2 = no 3 = not sure. The query has numerics only, I would like to change the values in the report to actually be the text values and not the numerics. Can this be done?

Thanks

 

[scriverb]

Put the following into the control source property of the Textbox:

=Switch([choice]=1,"Yes",[choice]=2,"No",[choice]=3,"Not Sure", True,"No Data")

The No Data option is only there in case there was no choice of 1,2, or 3 in the field. Just change to whatever you want it to say if the records has no data.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[dhookom]

Another simple expression is:
=Choose([Choice], "Yes", "No", "Not Sure")

Duane
MS Access MVP
Find out how to get great answers faq219-2884.