Mod function

[Bryce]

I'm trying to use the Mod function that I use in Excel in
Access and it doesn't accept it. Any ideas on a formula
that will work within access?

 

[Brian Camire]

In Access, Mod is an operator (like +, -, *, etc.) not a function.

So, where in Excel you might use

MOD(13, 10)

to get the remainder after dividing 13 by 10, you would use

13 Mod 10

in Access.