Rounding anomoly

[rwboyden via AccessMonster.com]

In a report, a control with a souce using Round(number, 2)*100 produces the
correctly rounded figure (a percentage) on my machine (XP Access 2003) but
the unrounded figure on a client machine (also XP Access 2003). Any idea why
this might happen?

 

[Allen Browne]

There may be a different version of some library on the other PC, or it may
be a floating point issue, or (most likely) a difference in the way the data
type is being interpreted.)

Whatever the cause, you could probably work around it by multiplying by 100
first, and then rounding. Since you want an integer, I suggest you use
CInt() unless you need to return some Null values.

Try:
CInt(IIf([num] Is Null, 0, [num] * 100))

 

[rwboyden via AccessMonster.com]

There may be a different version of some library on the other PC, or it may
be a floating point issue, or (most likely) a difference in the way the data
type is being interpreted.)

Whatever the cause, you could probably work around it by multiplying by 100
first, and then rounding. Since you want an integer, I suggest you use
CInt() unless you need to return some Null values.

Try:
CInt(IIf([num] Is Null, 0, [num] * 100))

In a report, a control with a souce using Round(number, 2)*100 produces
thecorrectly rounded figure (a percentage) on my machine (XP Access
2003) but the unrounded figure on a client machine (also XP Access 2003).
Any idea why this might happen?

Allen - Thanks ... Problem solved!