Rounding up

[ozzroo]

Hi there

I am having trouble using rounding up to the nearest 5.

I have a query which calculates the .5% stamp duty on a cheque amount.

So a cheque for £1200 pays £6 stamp duty.

My calculation in the query for rounding up is

RoundedSD: (([StampDuty]+4)\5)*5

Which gives me £10 stamp duty on a £1200 cheque. That is correct.

However, on a cheque for £55000, the should be £275 stamp duty. But my calculation above gives me £280. (275+4 = 279 - rounded to 275.

How do i get it so if its on a multiple of 5, it stays at that amount

 

[Crowley16]

have you thought about using the round function?

in access it can only do decimals, so divide your figure by 10, round it, and then multiply by 10

--------------------
Procrastinate Now!

 

[ozzroo]

Any idea how i would convert the above calculation into a round function

havent used that function that much, so dont know how to write it in a query

 

[MichaelRed]

search these fora (Tek-Tips) for basRoundTo (maybe basRound2?) anyway, something similar to basRound ...



MichaelRed