RE: 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.
.

Relevant Pages

  • RE: Percentage deduction Problem in Access Form
    ... and the format for this control is "Currency" ... I have another Control Box which is showing the percentage of deduction from ... ok now in the Third Control box i want to show the Net Amount which means ...
    (microsoft.public.access.forms)
  • RE: Percentage deduction Problem in Access Form
    ... and the format for this control is "Currency" ... I have another Control Box which is showing the percentage of deduction from ... ok now in the Third Control box i want to show the Net Amount which means ...
    (microsoft.public.access.forms)
  • Percentage deduction Problem in Access Form
    ... and the format for this control is "Currency" ... I have another Control Box which is showing the percentage of deduction from ... ok now in the Third Control box i want to show the Net Amount which means ...
    (microsoft.public.access.forms)
  • RE: Form calculation based on the date - How to????
    ... Access can't find the macro 'txtTotalDollarAmount_Bound = ... "Could it be that the control source for the form's field is now no longer ... txtTotalDollarAmount or txtTotalDollarAmount_Bound ... ... date field and then run the correct macro calculation based on that date. ...
    (microsoft.public.access.modulesdaovba)
  • Re: .visible property not firing
    ... events was their timing in relation to the calculation of the control. ... Try the OnCurrent event of the main Form, and the OnCurrent each of the ... I want to compare that third calculation with a field on ...
    (comp.databases.ms-access)