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

On Fri, 23 Mar 2007 10:45:29 -0700, ghost wrote:

> 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

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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."

"ghost" <(E-Mail Removed)> wrote in message
news:E717FD40-3F72-4783-A564-(E-Mail Removed)...
> 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