how to convert number to letter

[ghost]

hi,
i have to fileds for suming numbers. one of them for showing the sum in
number, and the other one for showing the sum but in letters.
can any body tell me how to convert the numbers to letters
e.g.
1 > one
100> one hunderd
thanks

 

[fredg]

hi,
i have to fileds for suming numbers. one of them for showing the sum in
number, and the other one for showing the sum but in letters.
can any body tell me how to convert the numbers to letters
e.g.
1 > one
100> one hunderd
thanks

See....
Modules: Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm

 

[Al Campagna]

Ghost,
http://www.mvps.org/access/modules/mdl0001.htm

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."