Mod
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.
 Query
The results using a Query would be
SELECT 10 MOD 5;
 FORM
In a Form you could set the Default Value of a Textbox to
= 10 Mod 5
 VBA
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
End Sub
Courses
Access Expert 8
|
Access Expert 26
 Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
| 
