MOD( )
Returns the modulo value for a number and a divisor.
Syntax
MOD(number, divisor)
Arguments
number
The number from which to derive the mod value.
divisor
The divisor for the mod function.
Returns
Returns the remainder value of number divided by divisor.
Example
The following example computes the remainder of PriceEstimate data field divided by 12, returning an integer. For example, if the PriceEstimate value is 27365, MOD( ) returns 5.
MOD([PriceEstimate], 12)