Convert precent to text

  • Thread starter Thread starter Starr McGrath via AccessMonster.com
  • Start date Start date
S

Starr McGrath via AccessMonster.com

Is there a code available to convert percent to text i.e. 5.625% to Five and
five eights percent?
 
http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web" shows how
to convert $500 to Five Hundred Dollars. Unfortunately, converting .625 to
five eights isn't going to be that simple. If you could live with that being
"and six hundred twenty-five thousandths", you could split the value in two:
what's before the decimal and what's after, and use an adapted version of
the code above twice.
 
Your best bet might be Goggle searches on these Access groups on
"convert percent to text" and similar phrases.

HTH
 
Back
Top