Replacing the numeric values of a field in querry

[boge]

Hi

I am trying to replace the numeric values of a field with a text in querry using Choose function, something like this aa5:

Choose([a5]-1="one";[a5]-2="two";[a5]-3="three";[a5]-4="four")

But it is not giving me no results ( I am missing something but I do not what. Maybe I should use some other function?

I hope someone will help me!

 

[boge]

There is another way for this, with another table (with two columns - one numbers, other the text values) and then relationship one-to-manny between colums with numbers, and finally lookup-querry