rounding to nearest 50

[foxhound]

Does anyone know the code that would round the value of a field to the nearest 50?

Foxhound

 

[bat17]

In a query use something like
MyNewNumber: Int(([MyOldNumber]+25)/50)*50

Peter

 

[Gates Is Antichrist]

cint() and clng() round off (though it seems anomalous; it seems that the general behavior of integer operations is to round down). Thus MyNewNumber: CInt([MyOldNumber]/50) works too.

 

[Gates Is Antichrist]

Of course, that should be
MyNewNumber: 50*CInt([MyOldNumber]/50)

 

[foxhound]

Thank you both very much. I tried each and they both seemed to work

 

[Eagle2003]

I am trying to round up to the nearest 1000. If I use:

1000*CInt([MyOldNumber]/1000

it rounds up/down. Any suggestions?

Thank you.

 

[Russell Hauf]

Try:

• 1000*(CInt((1000+MyOldNumber)/1000)

Hope this helps,

Russell

 

[Eagle2003]

Thanks for your reply. It still rounds up/down. For example, 12400 rounds down to 12000. I want it to round up to 13000.

Thanks.

 

[Russell Hauf]

It doesn't for me. I did have a paren missing though:

1000 * (CInt((1000 + MyOldNumber) / 1000))

If you placed it in the wrong place, it may have rounded incorrectly. When I used 12300 for MyOldNumber, I got 13000.

-Russell

 

[Gates Is Antichrist]

Russell that has an error. I believe you meant to use a 500 instead of 1000, as in 1000 * (CInt((500 + MyOldNumber) / 1000)).

Another way to go could be 1000 * (Int((999.999 + MyOldNumber) / 1000))

These all regard rounding UP, not NEAREST, as the thread was varied.