Solved

Rounding UP of currency in a query

Posted on 2007-11-20
6
460 Views
Last Modified: 2008-02-01
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
Comment
Question by:Paulo357
  • 3
  • 2
6 Comments
 
LVL 10

Expert Comment

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

Accepted Solution

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

Author Comment

by:Paulo357
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 10

Expert Comment

by:LennyGray
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

by:Paulo357
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

by:LennyGray
ID: 20331854
Thanks
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now