A Anthony Ching Mar 15, 2010 #1 Does anyone know of a rotuine to convert a number into its equivalent in English, e.g. 400,000 = Four Hundred Thousand. Thanks.
Does anyone know of a rotuine to convert a number into its equivalent in English, e.g. 400,000 = Four Hundred Thousand. Thanks.
G Gina Whipp Mar 15, 2010 #2 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.
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.
A Al Campagna Mar 15, 2010 #3 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."
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."
