Display a calculated number as text or words?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JanT - 31 May 2007 21:09 GMT

I have a query that calculates the number of days to complete a job. In
other words it subtracts end date from start date. In a report I want to
display the number of days in words. 1 = one, 2 = two, and so forth.

Reply to this Message

RBear3 - 31 May 2007 21:35 GMT

I think this will point you in the right direction:

Convert numbers into words (dollar values)
How to print dollar values out in words:

Check http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web"

Signature

Hope that helps!

RBear3
.

>I have a query that calculates the number of days to complete a job. In
> other words it subtracts end date from start date. In a report I want to
> display the number of days in words. 1 = one, 2 = two, and so forth.

Reply to this Message