Rounding in Access

[MichelleM via AccessMonster.com]

I have a report created that gives an individual their stats for the week
(calls, times, etc.) The individual sees their stats, along with their
team's average.

On this average, I do not want any decimal places, but if the average comes
to 94.5%, it lists 94%. I also thought .5 was the cutoff to round up and it
should list 95%. This apparently is not the case.

Any help would be appreciated!

 

[Duane Hookom]

You are experiencing "bankers" rounding. Even numbers will round .5 down
while odd numbers will round .5 up.
94.5 rounds to 94
95.5 rounds to 96

 

[MichelleM via AccessMonster.com]

Is there anyway to get around this?

You are experiencing "bankers" rounding. Even numbers will round .5 down
while odd numbers will round .5 up.
94.5 rounds to 94
95.5 rounds to 96

I have a report created that gives an individual their stats for the week
(calls, times, etc.) The individual sees their stats, along with their

[quoted text clipped - 5 lines]

Any help would be appreciated!

 

[John Spencer]

Sure add .000001 to the value.
..945 Plus .000001 will round up to .95 (95%)

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Is there anyway to get around this?

You are experiencing "bankers" rounding. Even numbers will round .5 down
while odd numbers will round .5 up.
94.5 rounds to 94
95.5 rounds to 96

I have a report created that gives an individual their stats for the week
(calls, times, etc.) The individual sees their stats, along with their

[quoted text clipped - 5 lines]

Any help would be appreciated!