Appreciate any feedback on the MOD function. I am at a loss to

understand its "mathmatics".

From the help

Result = Number1 MOD Number2 where the result should be the remainder

of the division.

Create a quick form with 3 unbound fields where the values are all

stored as either double or long (doesnt seem to make any difference in

this case) a quick bit of code and we can play and see the results.

Ok lets try 19 Mod 6.7 in normal "maths" we end up with 2.835

(19/6.7)=2.835, we would expect to see the remainder as .8 however we

end up with .5

With 103 / 16 we would expect to see 6.437 (a remainder of .4),

however with the MOD function we get 7.

Obviously I'm missing something here,

TIA