Round Function

[dspinner]

I am in a HR data base and I want to round everyone's salary (Field name [rate]) up to the nearest 500. I use this formula

Round([rate],500)

But it does NOTHING. I use a rate such as 23,555 and that is the product

Any suggestions?

 

[Mile-O]

The second argument of the Round function is the number of decimal places you want to round the number to. 23555.00000000 -> 500 Os is still 23555.

This is what you want; I think - my rounding may be dodgy as that'll probably go the nearest 100 rather than 500.

=Int([Rate]/100)*100

My maths is off...

 

[dspinner]

It does go to the nearest 100. But we are getting closer

ANd I want it to always round UP

There is a function in EXCEL called CEILING, which does this, but i cannot find it in Acess....

 

[Mile-O]

Eureka!

=(Int(([Rate])/500)*500)+500