Using MOD() in reports

[Russ H.]

Can the MOD() function be used successfully in Access
reports? The help screens say it should work and I'm sure
the syntax is OK, but when that function is inserted into
a text box it displays an error when the report is
displayed. THANKS.

Access2000.

 

[Duane Hookom]

Your expression should use something like:
X MOD Y

 

[Fredg]

Russ,
You haven't shared with us the exact expression you are using, so I can't
comment on that. I can suggest is that you make sure the name of this
control is not the same as the name of any of the fields used in the
expression. That will cause an #error.

 

[Bruce M. Thompson]

Can the MOD() function be used successfully in Access

reports? The help screens say it should work and I'm sure
the syntax is OK, but when that function is inserted into
a text box it displays an error when the report is
displayed. THANKS.

Access2000.

The Excel MOD() function cannot normally be used in Access. In Access, MOD is
not a function, but an operator and its usage has already been explained in
Duane Hookom's reply.