problem with rounding

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

Guest

I have a report that shows a column of numbers and then a total at the
bottom. I need the numbers to be to 3 decimal places. But I'm having a
problem if the total ends in a zero. Here's an example.

23.378
23.514
23.578
Total: 70.471

If I do it on the calculator is says the total is: 70.47. Meaning the last
number should be a "0" i.e. 70.470. But the report shows it as 70.471.
Everything is set to standard with 3 decimal places.

Any suggestions??

Thanks so much for any thoughts.

AT
 
even though you specified in the field that you want only three digit access
will remember the full number and it might have more then four digits
23.3785
23.5145
23.5780
Total: 70.471

try and format the field in the query that the report is bounded to,display
that field in the report, and then add it up
format(myField,"#.000")
 
Back
Top