MOD function

[letsalllaugh]

Can someone please spare a few minutes?

Can't get this to work. I require the 'remainder' part of a calculation:
I'm using =MOD(Integer1,Integer2)

in a Form, but I'm getting the syntax error 'You may have entered a coma
without a preceding value or identifier"

Works perfectly in Excel.

Any help would be greatly appreciated.

BTW I'm Running XP HE & Office 2000Pro
Thank you,,
Ali F

 

[Ken Snell [MVP]]

MyOriginalNumber Mod Divisor

Mod is an operator in ACCESS VBA, not a function.

 

[Douglas J. Steele]

In Access, it's =Integer1 MOD Integer2

 

[letsalllaugh]

Many thanks for the prompt reply Doug,

I wonder how many other MS Help files show the wrong Syntax???

Thanks again.

 

[fredg]

Many thanks for the prompt reply Doug,

I wonder how many other MS Help files show the wrong Syntax???

Thanks again.

** Snipped **

There's plenty of things wrong with Access help, but the help file on
MOD is not one of them.
Functions and operators are best searched for in VBA help.
It's quite clear and easy enough to find there.

Mod Operator

Used to divide two numbers and return only the remainder.

Syntax

result = number1 Mod number2

** Snipped **

Remarks

The modulus, or remainder, operator divides number1 by number2
(rounding floating-point numbers to integers) and returns only the
remainder as result. For example, in the following expression, A
(result) equals 5.

A = 19 Mod 6.7