Gustav Brock
gustav at cactus.dk
Sat Dec 24 09:31:24 CST 2011
Hi Mark Round is and has always been buggy. It is not the same as it will never fit a purpose but for serious use it is not reliable. >From that site (from the link) you can run the test for any custom rounding function. As noted - and (still) to the surprise for many - the only function of VB(A) and Access Basic (version 2.0) too - that performs correct 4/5 rounding is Format. All the Cxxx converter functions perform Banker's Rounding which is not "wrong", just not "clean" 4/5 rounding as you learned in school. /gustav >>> marksimms at verizon.net 23-12-2011 14:27 >>> Thanks Gustav. Once again, we've got versions 2003, 2007, 2010. Are you sure MSFT did not "fix" Round in later versions ? So bottomline: VBA side....Format and Round produce difference results ? > Hint: The only native function of VB(A) that handles 4/5 rounding > correctly is Format. It is, however, not very fast so if speed is a > concern you have to run a custom function. And no, the VB(A) function > Round is not the answer to any serious task: > > > /gustav