Division Remainder

[Mark]

Is there a function to calculate the remainder of a
division?


e.g., 17 / 4 = 4 remainder 1

I want to use the 1.

 

[Nikos Yannacopoulos]

Mark,

Modulo function is built in Access. The syntax is
17 Mod 4
as per your example. Can be used in calculated fields in queries, calculated
controls on forms and in reports, in code, anywhere.

HTH,
Nikos

 

[Dale Fye]

Use the Mod operator

intRemainder = 17 mod 4

HTH
Dale

 

[Allen Browne]

Mod operator, e.g.:
Debug.Print 17 Mod 4