PST & GST

[invoice with stok number]

i download the invoice with stock number but i am not abe the enter the PST &
GST to be added to the total i have to put 15 % in the PST instead of 7 % in
PST and 7.% % in GST . the way i do it put the 15 % is added in GTS

 

[John Vinson]

i download the invoice with stock number but i am not abe the enter the PST &
GST to be added to the total i have to put 15 % in the PST instead of 7 % in
PST and 7.% % in GST . the way i do it put the 15 % is added in GTS

Well, then there is evidently something wrong with your Query, your
Form, or your Report, whichever it is that you're describing.

Can you please give us some help? We cannot see your database; please
describe your table structure, where you are doing this calculation
and how (for example, post the SQL view of the Query or the Control
Source property of the calculated form control).

Also remember that PST and GST are NOT Access terms; as an American I
can only hazard a vague guess what they might be, perhaps some sort of
sales tax. But I have no idea what distinguishes them from one
another.

John W. Vinson[MVP]

 

[invoice with stok number]

HI ! thanks for answering i live in canada and here we have 2 taxes PST is 7
% and it should be add to the sub total before calculating the GST that is
7.5 % that should be added to the sub total + PST . The 2 taxes added
arrived to 15% but we are suppose the calculate them seperatly . And i don't
seem to be able to enter the PST of 7 % this is why i put 15 % there but it's
not the way it is suppose to be done . I hope you understand what i mean .The
template i used is Sales invoice with stock number

 

[John Vinson]

HI ! thanks for answering i live in canada and here we have 2 taxes PST is 7
% and it should be add to the sub total before calculating the GST that is
7.5 % that should be added to the sub total + PST . The 2 taxes added
arrived to 15% but we are suppose the calculate them seperatly . And i don't
seem to be able to enter the PST of 7 % this is why i put 15 % there but it's
not the way it is suppose to be done . I hope you understand what i mean .The
template i used is Sales invoice with stock number

Ok... that explains the business need. It does not explain the
database context.

I have not installed (and don't intend to install) the template you
mention, so I don't know the structure of the tables, of the form, or
of the query you're using. YOU can see your database - I cannot!

Please describe the table structure, and where and how you are doing
these calculations. Please post the Control Source properties of the
textboxes and any code that you're using.

John W. Vinson[MVP]