Search results for query: *

Hi I have tried this and get a value I was not expecting. As an example: 33 Mod 4 = 0.25 (I assume this is how the MOD function should work) Instead I get: 33 Mod 4 = 1 Why?

Another question in the same vein - is there a simple character or operator for the MOD function (like the backslash for QUOTIENT)??? I would like to return a value equal to the remainder of a division.

Thank you Ken and Michael. Ken's suggestion has worked. It was sooo simple in the end. And yes Michael, everybody tells me to learn to code instead, but I have not yet bit the bullett. Thanks guys Chris

Thank you for your tips. I am trying to call the QUOTIENT workbook function from a SetValue action in a macro in MSAccess 2000. the Help Guide (Office Assistant) does specify the QUOTIENT function can be called (along with a lot of other workbook functions). I can not however get any of them to...

How do I reference the Excel Workbook so I can use Workbook functions? I have referenced the workbook through Tools>References in the Module window and assume I have done it correctly. The function I want to use (QUOTIENT) returns the NAME# error when applied. The Help functions tells me I may...