Percentage deduction Problem in Access Form

R

Rizk

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.
 
R

Rizk

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top