"Modulas" Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
aMack said:
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?
Click to expand...

Yep...

3 mod 2 returns 1
 
To get the most benefit from the Mod function, you need to wear bell bottom
pants and an Afro hairdo.
 
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?
 
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


aMack said:
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


Rick Brandt said:
Yep...

3 mod 2 returns 1
Click to expand...
Click to expand...
 
YESSSSS!!!!!!!!!!


Thanks
--
A MACKENZIE, CMA, MBA


Roger Carlson said:
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


aMack said:
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


Rick Brandt said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top