|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 22nd, 2006, 06:02 PM
posted to microsoft.public.access.queries
|
|||
|
|||
"Modulas" Function
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? -- A MACKENZIE, CMA, MBA 
|
|
#2
November 22nd, 2006, 06:08 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"Modulas" Function
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 -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#3
November 22nd, 2006, 06:36 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"Modulas" Function
To get the most benefit from the Mod function, you need to wear bell bottom
pants and an Afro hairdo. "Rick Brandt" wrote: 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 -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#4
November 22nd, 2006, 06:51 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"Modulas" Function
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" wrote: 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 -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#5
November 22nd, 2006, 06:55 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"Modulas" Function
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/...UBED1=ACCESS-L "aMack" wrote in message ... 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" wrote: 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 -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#6
November 22nd, 2006, 08:27 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"Modulas" Function
YESSSSS!!!!!!!!!!
Thanks -- A MACKENZIE, CMA, MBA "Roger Carlson" wrote: 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/...UBED1=ACCESS-L "aMack" wrote in message ... 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" wrote: 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 -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#7
November 22nd, 2006, 10:27 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"Modulas" Function
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 -- Lynn Trapp Microsoft MVP (Access) www.ltcomputerdesigns.com
|
|
#8
November 22nd, 2006, 11:21 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"Modulas" Function
On Wed, 22 Nov 2006 16:27:05 -0600, "Lynn Trapp"
wrote: 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 Never trust anyone over 46! updated from an earlier version... John W. Vinson[MVP]
|
|
#9
November 23rd, 2006, 12:24 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"Modulas" Function
"Lynn Trapp" wrote in message ... 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 Or just to have seen the movie! :-) http://en.wikipedia.org/wiki/Quadrophenia_%28film%29 -- Brendan Reynolds Access MVP
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
