|
 |
access thread: Currency conversion to text
Message #1 by "Ray Pinnegar" <r.pinnegar@n...> on Tue, 23 Jul 2002 11:28:06
|
|
Rather than re-invent the wheel, has anyone got a simple sub-routine to
convert a numeric amount (e.g. $9420.30) to text (e.g. NINE THOUSAND FOUR
HUNDRED AND TWENTY DOLLARS AND 30 CENTS) for printing on cheques,
invoices etc.
Thanks in anticipation
Ray
Message #2 by "Richard Lobel" <richard@a...> on Tue, 23 Jul 2002 05:41:57 -0700
|
|
Ray,
>Rather than re-invent the wheel, has anyone got a simple sub-routine to
convert a numeric amount (e.g. $9420.30) to text (e.g. NINE THOUSAND
FOUR
HUNDRED AND TWENTY DOLLARS AND 30 CENTS) for printing on cheques,
invoices etc.<
A simple sub-routine? No. But I do have a set of functions to accomplish
this task. Too long to post here but I will send them via e-mail to you
directly.
Richard Lobel
President
NoClassroom.com
Live Software training
Right over the Internet
richard@n...
Tel: (xxx) xxx-xxxx
Fax: (xxx) xxx-xxxx
Message #3 by Chris Seier <chrisseier@c...> on Tue, 23 Jul 2002 17:50:03 -0400
|
|
Try this link:
http://www.mvps.org/access/modules/mdl0001.htm
Chris
> -----Original Message-----
> From: Ray Pinnegar [mailto:r.pinnegar@n...]
> Sent: Tuesday, July 23, 2002 11:28 AM
> To: Access
> Subject: [access] Currency conversion to text
>
>
> Rather than re-invent the wheel, has anyone got a simple sub-routine to
> convert a numeric amount (e.g. $9420.30) to text (e.g. NINE THOUSAND FOUR
> HUNDRED AND TWENTY DOLLARS AND 30 CENTS) for printing on cheques,
> invoices etc.
>
> Thanks in anticipation
> Ray
>
Message #4 by "John Ruff" <papparuff@c...> on Tue, 23 Jul 2002 15:17:09 -0700
|
|
You can also go to
http://support.microsoft.com/default.aspx?scid=kb;en-us;q95640 (watch
wordwrapping). It uses the Norwind db as an example.
John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities
www.noclassroom.com
Live software training
Right over the Internet
Home: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
9306 Farwest Dr SW
Lakewood, WA 98498
"Commit to the Lord whatever you do,
and your plans will succeed." Proverbs 16:3
-----Original Message-----
From: Ray Pinnegar [mailto:r.pinnegar@n...]
Sent: Tuesday, July 23, 2002 11:28 AM
To: Access
Subject: [access] Currency conversion to text
Rather than re-invent the wheel, has anyone got a simple sub-routine to
convert a numeric amount (e.g. $9420.30) to text (e.g. NINE THOUSAND
FOUR
HUNDRED AND TWENTY DOLLARS AND 30 CENTS) for printing on cheques,
invoices etc.
Thanks in anticipation
Ray
|
|
|
View Cart
