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