2 decimal rounding

  • Thread starter Thread starter Brad P
  • Start date Start date
B

Brad P

Hello...

I have this control source in a text box in a report:

=[SumOfMileage] & " km x " & [MileageRate] & " = $" &
Round([SumOfMileage]*[MileageRate],2)

SumOfMileage is 2 decimal places. MileageRate is 2 decimal places. Yet, the
Sum * Rate will not show a 100th place 0, eg. it can read 82 km + $0.3 =
$24.6

How can I get it so display $24.60?

Thanks
 
Brad said:
Hello...

I have this control source in a text box in a report:

=[SumOfMileage] & " km x " & [MileageRate] & " = $" &
Round([SumOfMileage]*[MileageRate],2)

SumOfMileage is 2 decimal places. MileageRate is 2 decimal places. Yet, the
Sum * Rate will not show a 100th place 0, eg. it can read 82 km + $0.3 =
$24.6

How can I get it so display $24.60?

Thanks
Click to expand...
Brad,
Try:
=[SumOfMileage] & " km x " & [MileageRate] & " = $" &
Format([SumOfMileage]*[MileageRate],"#.00")

Or... you can include the "$" within the Format function
:
=[SumOfMileage] & " km x " & [MileageRate] & " = " &
Format([SumOfMileage]*[MileageRate],"$ #.00")
 
Back
Top