I have created a report in Access that needs to show currency amounts. I have my field in my table set to currency and the report pulls off a query that also shows the currency properly. However, when I generate the report it only shows it in a number. I have formatted to currency and tried every trick I know. What am I missing?
Most Commented Posts
- August 8, 2008 -- Should "In God We Trust" Remain On American Currency? (41)
- February 26, 2009 -- Xtian: What right (specifically) would be violated by removing "In God We Trust" from US currency? (41)
- January 27, 2010 -- Do conservatives invest in gold because they have no faith in American currency? (37)
- November 24, 2008 -- Is “In God We Trust” on US currency a true statement? (35)
- January 3, 2009 -- Should the motto “In God We Trust” be removed from U.S. currency? ? (34)
- March 17, 2009 -- R&S what do you feel about "One nation under God" on US currency? (34)
- April 21, 2009 -- What would be the impact on American society if "In God We Trust" were removed from the currency? (34)
- May 7, 2008 -- Who else thinks that "in god we trust" should be removed from US currency? (33)
- January 9, 2009 -- Are coins and currency the same thing? (30)
- March 8, 2010 -- If your good looks were currency, what could you buy? (30)
This entry was posted
on Friday, December 25th, 2009 at 3:15 am and is filed under Currency Trading.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
December 25th, 2009 at 3:15 am
Hello Stacks52… ,
I’m not totally familiar with Forms in access, although how about if you click in the number field on your form and choose properties, the change the format to currency.
Hope this helps,
dtcom