Rounding problem

[Associates]

Hi,

I have a problem with rounding up or down when it comes to 3 decimal points.
In the Access reports, there are some data of type "currency". What i found
is that

When reporting to 2 decimal places, the Database report is currently
rounding down for situations like xxxx.xx5 when I believe it should be
rounding up, consistent with convention.

Is there any way of working around this for Access 03?

Thank you in advance

 

[Allen Browne]

When you round in Access, it uses bankers rounding. That is:
1-4 are rounded down;
6-9 are rounded up;
5 is rounded towards the previous even digit.

For example, 2.345 is rounded down to 2.34 (4 is even),
but 2.375 is rounded up to 2.38 (7 is odd.)

If that is not what you are experiencing, perhaps Access is treating the
data as floating point instead of currency (typically in a calculated
field), where floating point accuracy sometimes interferes:
http://en.wikipedia.org/wiki/Floating_point#Accuracy_problems

Or perhaps the data is not actually being rounded at all. Just setting the
Format of the control rounds only the display of the data, not the actual
value.

 

[Michiel Rapati-Kekkonen]

Amazing!
And good to know.

Michiel

When you round in Access, it uses bankers rounding. That is:
1-4 are rounded down;
6-9 are rounded up;
5 is rounded towards the previous even digit.

For example, 2.345 is rounded down to 2.34 (4 is even),
but 2.375 is rounded up to 2.38 (7 is odd.)

If that is not what you are experiencing, perhaps Access is treating the
data as floating point instead of currency (typically in a calculated
field), where floating point accuracy sometimes interferes:
http://en.wikipedia.org/wiki/Floating_point#Accuracy_problems

Or perhaps the data is not actually being rounded at all. Just setting the
Format of the control rounds only the display of the data, not the actual
value.