quotient function in excel

[Guest]

I am helping a client replace yet another cumbersome excel spreadsheet with
an access mdb, he is using the quotient function in excel which returns the
integer portion of a division. Not rounding.

I am having trouble finding a way to duplicate this in a query, any
suggestions?

Thanks!

Angela

 

[MH]

INT([numerator]/[denominator])

Or am I missing something?

MH

 

[Marshall Barton]

I am helping a client replace yet another cumbersome excel spreadsheet with
an access mdb, he is using the quotient function in excel which returns the
integer portion of a division. Not rounding.

I am having trouble finding a way to duplicate this in a query, any
suggestions?

I think the Int function is all you need:
Int(n/d)

 

[Guest]

I was sure it was an easy answer! I guess that's a new function for me,

Thanks so much,

Angela

 

[fredg]

I am helping a client replace yet another cumbersome excel spreadsheet with
an access mdb, he is using the quotient function in excel which returns the
integer portion of a division. Not rounding.

I am having trouble finding a way to duplicate this in a query, any
suggestions?

Thanks!

Angela

Use the integer division symbol "\" to perform the division.

13/2 = 6.5
13\2 = 6

 

[Marshall Barton]

Use the integer division symbol "\" to perform the division.

13/2 = 6.5
13\2 = 6

I don't see where Angie said the numerator and denominnator
are both integers. The \ operator does unexpected things
with non integer operands. E.g. 10 \ 2.5

 

[knightconsulting]

for what it's worth you can set a reference to the Excel object
library and do anything you can in Excel with Access - probably not
necessary in this case but always an option.