Numbers to words

J

John

Hi

Is there a function in access which will convert a number into corresponding
words e.g. 21 becomes twenty first, 24 becomes twenty fourth and so on?

Thanks

Regards
 
L

Larry Daugherty

Access doesn't provide such a function. You could create one. You
might want to generalize it for several cases, the first two being
"ByDigit", "SyntacticallyCorrect", "Integer", .....

Just as sure as you do it for one class of number and expression
you'll find another need.

HTH
 
B

Bob Quintal

Access doesn't provide such a function. You could create one. You
might want to generalize it for several cases, the first two being
"ByDigit", "SyntacticallyCorrect", "Integer", .....

Just as sure as you do it for one class of number and expression
you'll find another need.

HTH
Click to expand...

The Original Poster could also go to
http://www.mvps.org/access/modules/mdl0001.htm
and use the code posted there.
 
Top