Using the Mod (%) Operator
In this tutorial you will learn how to use the Mod Operator.
The Mod operator is used to divide two numbers and return only the remainder.
= (number) Mod (number)
number any valid number expression
In this example we will use 10 and 5.
The result is 0.
The results using a Query would be
SELECT 10 MOD 5;
In a Form you could set the Default Value of a Textbox to
= 10 Mod 5
In a Form add a TEXTBOX control and rename it "txtMod", then you could add the following in the Load Event.
Private Sub Form_Load()
txtMod = 10 Mod 5
Access Expert 8
Access Expert 26
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips