R
Ryan
GST and PST are the two types of sales tax used in Canada.
I'm reverse engineering an invoice template that I found at bullschmidt.com
to get it to incorporate the two types.
In my customer table, I added two yes/no fields, CustGST and CustPST. These
fields will be checked if the customer is exempt for a certain type of tax.
The default is "no".
I'm having trouble coming up with a statement that would to run the
calculation. My thought process is roughly (not proper code, just the idea)
if
CustGST=yes then (if CustGST = no then GST= 0)
GST = InvSubtotal * .07
/if
if CustPST=yes then (if CustPST = no then PST= 0)
PST = InvSubtotal * .08
/if
InvTotal = InvSubtotal + GST + PST
Should I be running this in a query or can I do all of this in the form
using the control source for each field?
I've told my boss that this project is a little bit over my head but he
wants me to go ahead anyways since I at least have an idea as to what the
requirements should be. Any help would be appreciated.
I'm reverse engineering an invoice template that I found at bullschmidt.com
to get it to incorporate the two types.
In my customer table, I added two yes/no fields, CustGST and CustPST. These
fields will be checked if the customer is exempt for a certain type of tax.
The default is "no".
I'm having trouble coming up with a statement that would to run the
calculation. My thought process is roughly (not proper code, just the idea)
if
CustGST=yes then (if CustGST = no then GST= 0)
GST = InvSubtotal * .07
/if
if CustPST=yes then (if CustPST = no then PST= 0)
PST = InvSubtotal * .08
/if
InvTotal = InvSubtotal + GST + PST
Should I be running this in a query or can I do all of this in the form
using the control source for each field?
I've told my boss that this project is a little bit over my head but he
wants me to go ahead anyways since I at least have an idea as to what the
requirements should be. Any help would be appreciated.