Expression Builder: MOD Function

[dgkindy]

trying to use the MOD function in the expression builder but comes up with an error

MOD(5,2)

This is an example. The error reads,

"The Expression you entered containes invaild syntax. You may have entered a comma without a preceding value or identifier"

When I look in the function list, I do not see the function. Any one have any idea?

 

[KenHigg]

I don't use it very much but I think the syntax is:

x = number1 Mod number2

???

 

[MSAccessRookie]

trying to use the MOD function in the expression builder but comes up with an error

MOD(5,2)

This is an example. The error reads,

"The Expression you entered containes invaild syntax. You may have entered a comma without a preceding value or identifier"

When I look in the function list, I do not see the function. Any one have any idea?

I think that the syntax for the MOD function is incorrect.

Instead of using MOD(5,2)

Try 5 MOD 2

I did and it returned the correct value of value 1

 

[RuralGuy]

Mod is an arithmetic operator, not a function so look under Operators for the syntax.

 

[dgkindy]

Are you entering this into the expression builder as part of a query. I have tried both ways and no loving.

Can you cut and past the expression that you got to work from your query.

I think 5 mod 2 is a VB format.

 

[KenHigg]

I think the format mod() is an excel function. You may need to check your references for excel objects - ?

 

[RuralGuy]

How about you post what you have tried so we can see what you are trying to accomplish. It is not real clear.

 

[MSAccessRookie]

I think that the syntax for the MOD function is incorrect.

Instead of using MOD(5,2)

Try 5 MOD 2

I did and it returned the correct value of value 1

As I pointed out already. I tried the exact syntax above using MS Access 2003, and the following query worked:

SELECT (5 mod 2)
FROM Table8;

For what it is worth, I agree with RuralGuy. We can provide formula options all day long, but if we do not know what we are building, we will find it difficult to help you choose the correct formula.

 

[raskew]

Straight from the Help File --> Operators --> Arithmetic --> MOD Operator

This example uses the Mod operator to divide two numbers and return only the remainder. If either number is a floating-point number, it is first rounded to an integer.

Dim MyResult
MyResult = 10 Mod 5	' Returns 0.
MyResult = 10 Mod 3	' Returns 1.
MyResult = 12 Mod 4.3	' Returns 0.
MyResult = 12.6 Mod 5	' Returns 3.

HTH - Bob

 

[Zyborgmonkey]

Ditto, worked for me.

Explained here also, with big words and pictures! XD :
https://theaccessbuddy.wordpress.co...s-that-you-should-know-operator-types-1-of-5/

 

[Uncle Gizmo]

with big words and pictures!

I haven't explored that website in detail but one article I found on importing spreadsheets into Access well, that was very clever and impressive! it's here:-

Quick way to Import Multiple Excel Files into MS Access

Recently, I had requested a big size of sales/inventory data from one of our internal team. While the data was available at a reasonable level of detail, it was too big to come in one spreadsheet. …

theaccessbuddy.wordpress.com

Is that your website Zyborgmonkey?