Convert precent to text

[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?

 

[Douglas J Steele]

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.

 

[Larry Daugherty]

Your best bet might be Goggle searches on these Access groups on
"convert percent to text" and similar phrases.

HTH