Round Off To The Hundreds

  • Thread starter Thread starter James Bond
  • Start date Start date
J

James Bond

999 / 6 = 166.5 -> 200

The figures above shows my problem!
I want Access to round off the quotient or product to the
hundreds automatically.

Please help me how.
Thanks and more power!
 
999 / 6 = 166.5 -> 200

The figures above shows my problem!
I want Access to round off the quotient or product to the
hundreds automatically.

Please help me how.
Thanks and more power!
Click to expand...

Try

100*CLng(<expression> / 100)
 
-----Original Message-----


Try

100*CLng(<expression> / 100)



.
Click to expand...

Again,

what about 999/9 = 167 -> 200
or 999/8 = 125 -> 200

The purpose of this to get the Maximum Authorize Cost.
Need your help again!
Thanks
 
Again,

what about 999/9 = 167 -> 200
or 999/8 = 125 -> 200

The purpose of this to get the Maximum Authorize Cost.
Need your help again!
Thanks
Click to expand...

I guess I don't understand the question.
 
-----Original Message-----


I guess I don't understand the question.



.
Click to expand...
Instead of rounding off to the "normal process" (any
number with 5 above on its "right" side would round "UP"
and any number 4 below on its "right" side would
round "DOWN"). But indeed, it would round "UP" to the
highest hundreds.

I hope you get my point now...
Thanks again!
 
Instead of rounding off to the "normal process" (any
number with 5 above on its "right" side would round "UP"
and any number 4 below on its "right" side would
round "DOWN"). But indeed, it would round "UP" to the
highest hundreds.
Click to expand...

DUH! ok, yes that should have been obvious.

Ok, try this:

100 * <expression> \ 100 + IIF(<expression> MOD 100 = 0, 0, 100)
 
Back
Top