ROUND function

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

I discovered that the ROUND function in Access 2002 to be
inconsistent. If I have an even number (in decimal
places) preceding a 5, my figure rounds down otherwise it
rounds up. I was wondering if there is any solution to
get some consistent rounding.
 
Access uses what is sometimes referred to as "Banker's Rounding" or
"Scientific Rounding". Theoretically, it is more accurate because at the .5
mark it rounds up half of the time and down half of the time, reducing the
skewing of the data by always rounding up (1-4 round down, 6-9 round up, 5
goes each way). At .5 it will round to the nearest even number.

Then only way around this is to write your own rounding function. Place it
in a module and call it just as you would the current Round function.

Example:
http://www.mvps.org/access/modules/mdl0054.htm
 
I would like to use it with the same rounding like Excel to filter those matched records in the access 2000 queries/table. Please help to fix this point.
 
Back
Top