anyone know what code to use to find the modulus of a field?
D Duane Hookom Dec 29, 2004 #3 Did you try open any module in Access and press F1. Search on "modulus". You will find the "Mod" operator with examples.
Did you try open any module in Access and press F1. Search on "modulus". You will find the "Mod" operator with examples.
B blackcat Dec 29, 2004 #4 not sure, i can't seem to get the code right, any idea's in that direction would be great
A Allen Browne Dec 29, 2004 #5 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.
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.