How to turn Number to text

[Guest]

I want to convert my numbers from an access table to a query in text.
I checked the http://www.mvps.org/access/modules/mdl0001.htm
but i didn't know how to use it!
can any body tell me how to use it in an Access query?
Plese contact me on my email.
Alex

 

[John Nurick]

Hi Alex,

Paste the code into a module in your Access database. Then use a
calculated field like this in your query, where X is the name of the
numeric field:

TextValue: IIF(IsNull([X]), Null, English(CCur(Nz([X], 0))))

 

[HOMI]

If I understand you correctly you want to convert 123
to "123" use the cstr function ina update query