 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2008how do i set up the formula to calculation 10% off in a query .
i am trying to run a query that will give me 10% off any price i would like to know if you can please show me what the formula for this would look like in microsoft access 2007 To calculate the discount [Your Price Field] * .1 To calculate the discounted price [Your Price Field] * .9 Or [Your Price Field] - [Your Price Field] * .1 You may want to do some rounding or other manipulation to ensure that you are returning the price to the nearest penny (in the US) or other monetary unit in other parts of the world. '==================================================== John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County '==================================================== > i am trying to run a query that will give me 10% off any price > i would like to know if you can please show me what the formula for this > would look like in microsoft access 2007 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.