 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Percentage deduction Problem in Access Form
Dear users, I am stuck with a very simple problem but I really don't know how to solve it, I have the bound Control Box which showing the Grand Total of the amount in an invoice, and the format for this control is "Currency" I have another Control Box which is showing the percentage of deduction from the Grand Total. ok now in the Third Control box i want to show the Net Amount which means Grand Total minus deduction percentage, Grand Total = 739.20 Deduction = 5.303% Net Total should be = 700 in the Net Total I create unbound box and I write = [GrandTotal]-[Deduction] what I am getting is 739.147, I know the way I am writing the code is the same way I do it using a calculater and I know there is a very simple way to write the code by access, so kindly help me. thanks a lot. Your calculation should be: =[Grand Total] - ([Grand Total] * [Deduction])  SignatureBob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ > Dear users, > I am stuck with a very simple problem but I really don't know how to solve it, [quoted text clipped - 11 lines] > same way I do it using a calculater and I know there is a very simple way to > write the code by access, so kindly help me. thanks a lot. Actually I got it wrong. It should be = 1-([Deduction]/100)*[Grand Total] SignatureBob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ > Dear users, > I am stuck with a very simple problem but I really don't know how to solve it, [quoted text clipped - 11 lines] > same way I do it using a calculater and I know there is a very simple way to > write the code by access, so kindly help me. thanks a lot. Hello bob, thanks a lot, it works, but without the 1- I only made it like = ([Deduction]/100)*[Grand Total] thanks again. best regards. > Actually I got it wrong. > [quoted text clipped - 17 lines] > > same way I do it using a calculater and I know there is a very simple way to > > write the code by access, so kindly help me. thanks a lot. |
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
|
©2008 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.