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
Petermcg001Asked:
Who is Participating?
 
zane_oConnect With a Mentor Commented:
Missed the always round up part. If you combine the two responses here, you get something like:
 Int(-20 * [Amount]) / -20
0
 
zane_oCommented:
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
 
Randy DownsOWNERCommented:
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
 
Petermcg001Author 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.

All Courses

From novice to tech pro — start learning today.