calculate GST tax rate

[MB77007]

Invoicing for our organization allows users to select when GST (Canada - 7%)is applicable or if a manual amount is to be added. In order words, most invoices include the GST but some do not in the final total. GST rate will be changing as of July 1 to 6% but I am unable to figure out how to change the rate. The control source for text box GST in subform reads: IIf([Manual GST]=0 Or IsNull([Manual GST]),Sum(FixQty([Qty])*[Unit Price]*Abs([GST?]))*TaxRate(),[Manual GST]). Subform consists of Subtotal, GST Amount, if applicable, and total. I am not very experienced with using calculated controls + advanced forms but would very much appreciate some help in working this problem through. Thank you.

 

[ssatech]

Is there a field in a table (e.g. Company Information) that has the GST Rate or a field with GST Rate in the table, the recordsource behind this form that uses this data to calculate the GST?

 

[MB77007]

Thanks for the suggestion I was hoping that would be the case; however, there are 4 tables but none has field that would contain GST rate. I'm wondering if - because the calculation might be GST exempt - there might be more to it. I did find query called Excel GST which reads: SELECT [Excel Data].Customer, [Excel Data].[Invoice #], "GST" AS Description, Sum([Qty]*[Unit Price]*Abs([GST?]))*TaxRate() AS GST
FROM [Excel Data]
GROUP BY [Excel Data].Customer, [Excel Data].[Invoice #]
This form was created in 1999 so we are using older Access software in this instance.

 

[ssatech]

Not to familiar with the Canadian tax system. But is not the TaxRate the same as the GST Rate? Is the Tax Rate set to default to 7%?

 

[MB77007]

Thank you for hints. I was able to locate the designer of the form and will confer with him next week. Problem will be resolved at that time.