Bankers Rounding

  • Thread starter Thread starter Jeff Kaufman
  • Start date Start date
J

Jeff Kaufman

I am currently in Access 2003... Is there any way around having Access use
Bankers Rounding in Query Results.

For example

Field 1 / Field 2 = 3.5
I would like the results to round up to 4, not down to 3.
 
Access routinely uses banker's rounding when summing query results. If
you
Click to expand...

Or AIR, Access routinely uses Windows rounding, from a system DLL.
Windows rounding is almost like Bankers rounding, except for
some particular values. Windows uses a fast rounding algorithm.
(david)
 
Back
Top