# Rounding up in Access query

Hello,

I need a query that takes a price and rounds UP to the next 5p, i.e £2.36 should go to £2.40 and £5.12 should go to £5.15 etc.

Thanks
LVL 1
###### Who is Participating?

Commented:
Missed the always round up part. If you combine the two responses here, you get something like:
Int(-20 * [Amount]) / -20
0

Commented:
Rounding to 5p is done by multiplying the number by 20, rounding it, and dividing by 20 to get to the proper value.
Round(20 * [Amount], 0) / 20
0

OWNERCommented:
Try this - http://allenbrowne.com/round.html

Rounding up
To round upwards towards the next highest number, take advantage of the way Int() rounds negative numbers downwards, like this:
- Int( - [MyField])

As shown above, Int(-2.1) rounds down to -3. Therefore this expression rounds 2.1 up to 3.

To round up to the higher cent, multiply by -100, round, and divide by -100:
Int(-100 * [MyField]) / -100
0

Author Commented:
Thanks for looking at this.  zane o's solution works perfectly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.