If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Percentage 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. |
#2
|
|||
|
|||
Percentage deduction Problem in Access Form
Your calculation should be:
=[Grand Total] - ([Grand Total] * [Deduction]) -- Bob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ "Rizk" wrote: 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. |
#3
|
|||
|
|||
Percentage deduction Problem in Access Form
Actually I got it wrong.
It should be = 1-([Deduction]/100)*[Grand Total] -- Bob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ "Rizk" wrote: 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. |
#4
|
|||
|
|||
Percentage deduction Problem in Access Form
Hello bob,
thanks a lot, it works, but without the 1- I only made it like = ([Deduction]/100)*[Grand Total] thanks again. best regards. "boblarson" wrote: Actually I got it wrong. It should be = 1-([Deduction]/100)*[Grand Total] -- Bob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ "Rizk" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|