rounding a sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a calculated control on a report which I want to round to the nearest
dollar, but still show the 2 decimal places, even though they would be ".00".
The control's properties are set to Format = Currency, and Decimal places =
0, because I figured I could include a text at the end of the calculating
expression such as:
&".00"
I was thinking that it would read, as an example $8,690.00, but it returned
a result of 8960.46878587988.00. Certainly this is not a desired result.

Should I be taking a different avenue to achieve this? Any suggestions are
appreciated!
 
the Format = Currency, and Decimal places = 2.
it should make every number in the format $#,###.##
That should fix it, don't add the .00
 
So how do I get it to round so that the decimals are always ".00", and not
specific cents such as ".43"? Is there another property, or do I need to
round my source data in the query??
Thanks again!
 
sorry I didnt understand your question
So how do I get it to round so that the decimals are always ".00", and not
specific cents such as ".43"? Is there another property, or do I need to
round my source data in the query??
Thanks again!
Click to expand...
 
Kevin said:
I have a calculated control on a report which I want to round to the nearest
dollar, but still show the 2 decimal places, even though they would be ".00".
The control's properties are set to Format = Currency, and Decimal places =
0, because I figured I could include a text at the end of the calculating
expression such as:
&".00"
Click to expand...


A different way is to set the text box's Format property to
something like:

$#,##0".00"
 
Back
Top