Advise & Help on Calculation

[Fakhruddin Zavery]

Hello,

I have a form that is basically for entering or recording an Invoice for
customers, The operator would chose the services purchased and print it.
Each customers invoice/service items would be different.

My question is how can I calculate a VAT Amount(17%)? Because VAT for my
scenario is only applicable to one particular Service Only, the rest are not
supposed to be charged VAT Tax.

My service comes from a Table where there is a Service Code and Description.
I can display the Sub Totals for the Invoice on the Form, I can display the
Totals as well but this VAT Tax part am failing. How can I make the VAT Box
to be calculated automatically whenever this Service is Charged only and not
for any other? The same scenarion would apply when I print the report as
well.

Will appreciate all the help.
Thanks and Regards

Fakhruddin

 

[Steve Schapel]

Fakhruddin,

One approach might be to add another field to the Services table, for
VAT Rate. If I understand you correctly, all records would then have 0
entered in this field, except the one where the tax applies, and for
this one you would enter .17. Include this field in the record source
of your form. Then, in the Control Source of your VAT Box (assuming
this applies to a total, so it is in a group footer section of the form,
or the form footer), you can put the equivalent of...
=Sum([SalesAmount]*[VAT Rate]

 

[Fakhruddin Zavery]

Thanks Steve,

I'll give this a try and I am sure it will work.

Thanks and Regards
Fakhruddin

Fakhruddin,

One approach might be to add another field to the Services table, for
VAT Rate. If I understand you correctly, all records would then have 0
entered in this field, except the one where the tax applies, and for
this one you would enter .17. Include this field in the record source
of your form. Then, in the Control Source of your VAT Box (assuming
this applies to a total, so it is in a group footer section of the form,
or the form footer), you can put the equivalent of...
=Sum([SalesAmount]*[VAT Rate]

--
Steve Schapel, Microsoft Access MVP

Hello,

I have a form that is basically for entering or recording an Invoice for
customers, The operator would chose the services purchased and print it.
Each customers invoice/service items would be different.

My question is how can I calculate a VAT Amount(17%)? Because VAT for my
scenario is only applicable to one particular Service Only, the rest are not
supposed to be charged VAT Tax.

My service comes from a Table where there is a Service Code and Description.
I can display the Sub Totals for the Invoice on the Form, I can display the
Totals as well but this VAT Tax part am failing. How can I make the VAT Box
to be calculated automatically whenever this Service is Charged only and not
for any other? The same scenarion would apply when I print the report as
well.

Will appreciate all the help.
Thanks and Regards

Fakhruddin