Query not what I expected 1

[pduncan]

I am trying to calculate a tax based on taking a tax rate and multiplying it by the amount due. For some reason, the numbers are WAY off.
Here is the SQL from my query:

UPDATE tblInvoice SET tblInvoice.RegionalTax = ([tblInvoice]![TaxRate]*[tblInvoice]![RegionalAmountDue]);

I have been up all night watching the election returns and may be a little brain dead – but I am stumped.

Any help will be greatly appreciated.

PDUNCAN - MEMPHIS, TN

 

[PHV]

Obviously RegionalTax, TaxRate and RegionalAmountDue are numeric fields and you don't need to divide TaxRate by 100 ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

When you try this:
UPDATE tblInvoice SET RegionalTax = TaxRate * RegionalAmountDue;
can you please post some TaxRate, RegionalAmountDue value pair with the corresponding off way RegionalTax ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pduncan]

PHV - you nailed it - forgot to divide by 100. Thanks!

PDUNCAN - MEMPHIS, TN