Solved

Rounding UP of currency in a query

Posted on 2007-11-20
6
487 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

790 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