# "Modulas" Function

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?

R

#### Rick Brandt

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?

Yep...

3 mod 2 returns 1

G

#### Guest

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

G

#### 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?

R

#### Roger Carlson

Get rid of the commas:

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

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
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

G

#### Guest

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
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

L

#### 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

J

#### 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]