Numbers to words

[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

 

[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

 

[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

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

 

[pietlinden]

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

like this?
http://www.mvps.org/access/modules/mdl0047.htm