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