Using MOD() in reports

  • Thread starter Thread starter Russ H.
  • Start date Start date
R

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.
 
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.
 
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.
Click to expand...

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.
 
Back
Top