Hi,

I hoping someone can help me here. Can the Mod Function be used in the calculations of a report.

I have tried the following and all I keep getting the message shown below:

=Mod(Sum(Right([dtmTotalTime],2)),60)

Error Message:

"The expresssion you entered contained an invalid syntax. you may have entered a comma without a preceding value or identifier"

I looked up the syntax for the Mod function and this is what is provided in the help files

"MOD

Returns the remainder after a number is divided by a divisor.
Syntax
MOD(number,divisor)
Number is the number for which you want to find the remainder after the division is performed.
Divisor is the number by which you want to divide Number."


So I'm clearly doing something wrong, your assistance would be most appreciated.

John

The syntax is:
number MOD divisor

Yes you can use the MOD operator in a report.
hth
Chris

Hi Chris,

Thanks, I've just worked out before I got your response, what I was doing wrong, got it working now,

John