Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Rounding UP of currency in a query

Posted on 2007-11-20
Medium Priority
509 Views
Hello All, I have spent far too much time researching this question on the Q&A of this site, So I have resorted to asking the wealth of experts chasing points.
What is the A2K equivalent of this Excel formula please
=CEILING(C2,0.1)
This happly upgrades figures like \$13.02 to \$13.10 or \$32.58 to \$32.60
I would like to imbed a rounding up formula in my Query that does the same please

Regards P
0
Question by:Paulo357
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 3
• 2

LVL 10

Expert Comment

ID: 20325484
Ccur(round(CurrencyAmount  + .50))
0

Accepted Solution

Weddeh earned 200 total points
ID: 20325746
Round to 0.1
INT(<field>*10*-1)/10*-1
Round to 1
INT(<field>*-1)*-1
0

Author Comment

ID: 20330172
Sorry Lenny, you formula only rounded \$13.02 to \$14.00.
Weddeh, your formula  "INT(<field>*10*-1)/10*-1" is spot on rounding \$13.02 to \$13.10
cheers!
Paul
0

LVL 10

Expert Comment

ID: 20330639
No problem. I figured that you wanted rounding to the next dollar. Is that something particular to New Zealand?

I am happy that you were helped.

Who helps is not as important as who is helped.
0

Author Comment

ID: 20330714
No its not particular to NZ Lenny, its just I was tasked to do this rounding by my boss for a pricing senerio he is using
0

LVL 10

Expert Comment

ID: 20331854
Thanks
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
###### Suggested Courses
Course of the Month5 days, 11 hours left to enroll