Solved

Access 2003 query, round down to nearest 5 cents

Posted on 2016-10-11
3
45 Views
Last Modified: 2016-10-12
How do I get prices to round down to nearest nickle without using code? Id like to do it from with the query. Here's what Ive tried but it throws the price totally out of whack:

Round(20*products.price+inventoryprofile.estshipcost,0)/20

Thanks.
0
Comment
Question by:QMBB
[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
  • Learn & ask questions
3 Comments
 
LVL 25

Accepted Solution

by:
chaau earned 500 total points
ID: 41839307
You need to use brackets ( ) to make sure that the multiplication applies to the whole expression, not just the products.price:
Round(20*(products.price+inventoryprofile.estshipcost),0)/20

Open in new window

0
 

Author Closing Comment

by:QMBB
ID: 41839316
Woo hoo! Thanks.
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 41839631
No Woo Hoo, as this code doesn't round down but rounds to the nearest even.
Further, Round is buggy.

To round down, you need this:

    ListPrice: Int(20*(products.price+inventoryprofile.estshipcost))/20

If you have a serious need for rounding, study the options here:

Rounding values up, down, by 4/5, or to significant figures

/gustav
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
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…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

739 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