Calculation Help

[Simon Glencross]

I have a table called tblstock in this table I have a field called SalePrice
which is where the actual sale price is entered once this is entered I would
like for the field vat to be popullated with the amount of vat @ 17.5%

eg SalePrice £100 therefore VAT = £17.50

Any ideas on how to best do this?

Thanks in advance

 

[Graham Mandeno]

Hi Simon

I suggest you don't store the VAT amount in your Stock table, as
(presumably) the rate is the same for all stock items.

Instead, store the rate (17.5%) in your Sales table, and perform the
calculation of the amount on the fly in the queries that generate your forms
and reports (order entry, quotes, invoices, etc).

If you could trust the gummint never to change the rate then there would be
no need to store it at all, but we all know we could never do that