MS ACCESS

[J.Alladien]

I need a function that displays numbers as text f.e "1200" as
"twelvehundred"
please note I will need it to display the numbers one in ENGLISH and one in
DUTCH!


Does MS access support such a thing ?

 

[George Hester]

Prime numbers is one reason why this cannot be done.

 

[*raul*]

Probably you can easily adapt (simplify and translate) this function:

Convert Currency ($500) into words (Five Hundred Dollars)
http://www.mvps.org/access/modules/mdl0001.htm
(code by Joe Foster in "The Access Web")

Good luck!

 

[*raul*]

Another at the same site, may be better (if I am understanding your
request):

Spelling number, in many languages (PolyGlot Number Speller)
http://www.mvps.org/access/modules/mdl0047.htm
(code by Michel Walsh in "The Access Web")


*raul* ha escrito: