modulus

[blackcat]

anyone know what code to use to find the modulus of a field?

 

[Allen Browne]

Does the Mod operator do what you want?

 

[Duane Hookom]

Did you try open any module in Access and press F1. Search on "modulus". You
will find the "Mod" operator with examples.

 

[blackcat]

not sure, i can't seem to get the code right, any idea's in that direction
would be great

 

[Allen Browne]

Open the Immediate window (Ctrl+G)
Enter:
? 8 Mod 3

You should get the response:
2
because 8 divided by 3 gives a remainder of 2.