Bankers Rounding


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

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.

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