In this case 7.5 was rounded up to 8 before the calculation.

8 goes evenly into 24 three times leaving no remainder (0).

If the example were 24 Mod 7.4, the 7.4 would be rounded Down to 7.

7 goes into 24 three times (7*3 = 21). 24 - 21 = 3

24 Mod 7.4 = 3

Warning - there are articles you may want to search for regarding how Access

handles rounding. In some cases .5 may be rounded either up or down

depending on the precision of the variable type you declare

Len

"MLH" <CR**@NorthState.netwrote in message

news:c2********************************@4ax.com...

MyVariant = 24 mod 7.5

?MyVariant

0

Why does this return zero? I thought it

woudl be a number greater than zero.