Displaying Currency in Thousands

[BrianFawcett]

I am working on a forecasting report that has many values, mostly in the millions of dollars. I would like to display my $ fields in the thousands of $ so that I can make the text font larger and most easily readable. How do I do this so that instead of, for instance, $2,259,123, I display $2,259. Thanks.

 

[pbaldy]

One way would be the Round() function.

 

[bigalpha]

One way would be the Round() function.

Similarly - I see that Access does a 'banker's round'. So 1.3375 rounds to 1.337. What do I use to get it to round 1.3375 to 1.3338; and 1.3374 to 1.337?

 

[boblarson]

I would just set the expression to be

=[FieldNameHere]/1000

make sure that there are no controls on the report with the same name as the field and use the field name in the expression. You can set the decimals to 0 or whatever you want. My test indicates that the 13,375 will become 13.38 in thousands.

 

[CJ_London]

=[FieldNameHere]/1000

Only potential issue with this is if there are totals - since the values aren't rounded (only the display) they can make a difference on a page total for example - can be embarassing for accountants!

round 1.3375 to 1.3338; and 1.3374 to 1.337?

ans: Round(1.3375,3)

 

[ChrisO]

Why would 1.3375 ever round to 1.3338?

Chris.

 

[CJ_London]

I was assuming it was a typo.... and just copied as is