Access 2003

L

Leonardo Rivas

I made a numeric field in Access that calculates a given information. I want to convert the numbre obtained in that field into a text. For example, if i get "15" after the calculation, i would to represent the number as a text in another field, as "fifthteen". Can Anybody tell me how making this conversion?

Thanks!
 
X

x

oracle has this built in function....
i guess you have to convert it programmatically..
-----Original Message-----
I made a numeric field in Access that calculates a given
Click to expand...
information. I want to convert the numbre obtained in
that field into a text. For example, if i get "15" after
the calculation, i would to represent the number as a
text in another field, as "fifthteen". Can Anybody tell me
how making this conversion?
 
T

Tony Toews

Leonardo Rivas said:
I made a numeric field in Access that calculates a given information. I want to convert the numbre obtained in that field into a text. For example, if i get "15" after the calculation, i would to represent the number as a text in another field, as "fifthteen". Can Anybody tell me how making this conversion?
Click to expand...

Modules: Spelling number, in many languages (PolyGlot Number Speller)
http://www.mvps.org/access/modules/mdl0047.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top