"Modulas" Function

[Guest]

In Excel there is a "MOD" function which is described as "find the remainder
from wholly dividing an amount by a variable"

Is there such a thing in Access?

 

[Rick Brandt]

In Excel there is a "MOD" function which is described as "find the
remainder from wholly dividing an amount by a variable"

Is there such a thing in Access?

Yep...

3 mod 2 returns 1

 

[Guest]

To get the most benefit from the Mod function, you need to wear bell bottom
pants and an Afro hairdo.

 

[Guest]

I am trying to run this calc in a query.

It gives me a blank result:

((1st Value]+[2nd Value]),mod,11)

should give me 4 if Total Value = 6692

What am I doing wrong? Can this be run in an update query?

 

[Roger Carlson]

Get rid of the commas:

((1st Value]+[2nd Value]) mod 11)

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

I am trying to run this calc in a query.

It gives me a blank result:

((1st Value]+[2nd Value]),mod,11)

should give me 4 if Total Value = 6692

What am I doing wrong? Can this be run in an update query?
--
A MACKENZIE, CMA, MBA

Yep...

3 mod 2 returns 1

 

[Guest]

YESSSSS!!!!!!!!!!


Thanks
--
A MACKENZIE, CMA, MBA

Get rid of the commas:

((1st Value]+[2nd Value]) mod 11)

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

I am trying to run this calc in a query.

It gives me a blank result:

((1st Value]+[2nd Value]),mod,11)

should give me 4 if Total Value = 6692

What am I doing wrong? Can this be run in an update query?
--
A MACKENZIE, CMA, MBA

aMack wrote:
In Excel there is a "MOD" function which is described as "find the
remainder from wholly dividing an amount by a variable"

Is there such a thing in Access?

Yep...

3 mod 2 returns 1

 

[Lynn Trapp]

To get the most benefit from the Mod function, you need to wear bell

bottom
pants and an Afro hairdo.

It also helps to have been born prior to 1960

 

[John Vinson]

It also helps to have been born prior to 1960

Never trust anyone over 46! <updated from an earlier version...>

John W. Vinson[MVP]

 

[Brendan Reynolds]

It also helps to have been born prior to 1960

Or just to have seen the movie!

http://en.wikipedia.org/wiki/Quadrophenia_(film)