If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MSAccess report
I am currently formatting receipts. I want to be able to put the dollar
amount in both as numeral and words. Is there anyway to automate this so that $100 will generate One Hundred in a query or in the report itself? I do not know how to code but have some experience using Access for a fairly complex data base. -- Winefride |
#2
|
|||
|
|||
MSAccess report
On Tue, 15 Apr 2008 17:06:01 -0700, Winefride wrote:
I am currently formatting receipts. I want to be able to put the dollar amount in both as numeral and words. Is there anyway to automate this so that $100 will generate One Hundred in a query or in the report itself? I do not know how to code but have some experience using Access for a fairly complex data base. See: Modules: Convert Currency ($500) into words (Five Hundred Dollars) http://www.mvps.org/access/modules/mdl0001.htm -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
MSAccess report
Thank you for the code - but I have to admit I don't know how to apply it in
a query - how do I attach it to a query? -- Winefride "fredg" wrote: On Tue, 15 Apr 2008 17:06:01 -0700, Winefride wrote: I am currently formatting receipts. I want to be able to put the dollar amount in both as numeral and words. Is there anyway to automate this so that $100 will generate One Hundred in a query or in the report itself? I do not know how to code but have some experience using Access for a fairly complex data base. See: Modules: Convert Currency ($500) into words (Five Hundred Dollars) http://www.mvps.org/access/modules/mdl0001.htm -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#4
|
|||
|
|||
MSAccess report
On Wed, 16 Apr 2008 16:06:00 -0700, Winefride wrote:
Thank you for the code - but I have to admit I don't know how to apply it in a query - how do I attach it to a query? You don't attach it to a query. Here's what you do. Copy and paste the code ... everything between ************ Code Start ********** and ************ Code End ********** into a new module. Exit and save the module . Name it "mdlDollarsToText". Then, in your query, to convert the currency value into text, add a new column to the uery grid. TextDollars:English([CurrencyFieldName]) You can then use the [TextDollars] field in a report or wherever. If you are wishing to do this directly in a report (i.e. to actually print out a check), you would use, in an unbound text control: =English([CurrencyFieldName]) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|