[AccessD] Rounding with CCur conversion

Hi Lambert

Different features for different purposes. Banker's rounding is best for many purposed while the clean mathematical is best for many other purposes including rounding a single value. As for so many other things you as the developer just need to know what you are doing and pick the right tool.

/gustav


>>> Lambert.Heenan at aig.com 02-05-2008 15:28 >>>
<quote>
# VB6 Round rounds 1/2 to nearest the even number (aka 'Banker's rounding')
Round(1.5) => 2
Round(2.5) => 2 !! should be 3 in 'Other people's rounding'
</quote>

The "should be 3" comment gets me. Why would anyone wish to use a rounding
method that skews the results in one direction? For once the bankers might
have it right, IMHO. By alternately rounding up and down in a systematic way
you reduce skew. Which begs the question as to why Ccur() gets it wrong...