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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding 10
Truncate a number before rounding 2
Found a Bug or Error in Access 2002-2003 Round Function 3
Banker's Rounding - need help! 3
Rounding up! 2
Possible router problems 9
Access 2007: % fields rounding to nearest integer 3
Numbers keep rounding automatically!! 1

Back
Top