iamedwardkim
IS-IT--Management
Is there a way to format a number like 2379 to $2,379.00 from within the expression builder?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Currency formatting question 1
- Thread starter iamedwardkim
- Start date
- Status
-
1
- #2
You can use:
Format(numberhere, "Currency"
or
Format(numberhere, "$#,##0.00"
both produce the results.... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)
Robert L. Johnson III, MCSA, CNA, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com
Format(numberhere, "Currency"
or
Format(numberhere, "$#,##0.00"
both produce the results.... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)
Robert L. Johnson III, MCSA, CNA, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com
- Thread starter
- #3
iamedwardkim
IS-IT--Management
Thank you... It worked great.
Would anyone know if it's also possible to have a number like 2379 to be displayed as "Two Thousand Three Hundred and Seventy Nine"? or something similar to that?
Would anyone know if it's also possible to have a number like 2379 to be displayed as "Two Thousand Three Hundred and Seventy Nine"? or something similar to that?
Not inherent in access....but there are at least two FAQs within Tek-Tips (I know at least one in the Module FAQs and I think one in the Reports FAQs) that provide functions that will do this for you....
Credit belongs to the authors of these great FAQS... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)
Robert L. Johnson III, MCSA, CNA, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com
Credit belongs to the authors of these great FAQS... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)
Robert L. Johnson III, MCSA, CNA, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
