Converting a Number

[Anthony Ching]

Does anyone know of a rotuine to convert a number into its equivalent in
English, e.g. 400,000 = Four Hundred Thousand. Thanks.

 

[Gina Whipp]

Anthony,

Have a look at...

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

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Does anyone know of a rotuine to convert a number into its equivalent in
English, e.g. 400,000 = Four Hundred Thousand. Thanks.

 

[Al Campagna]

Anthony,
Try...
http://support.microsoft.com/kb/95640
or
http://www.fabalou.com/access/Modules/numbertowords.asp
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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