Input of constant date in access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I enter constant values to calculate e.g a price for each product
(Taxes, VAT, Margin on cost, transport, etc...). Such constant should stay
identical for all products? Thks
 
I'd create a little table

tblSettings
ItemName ItemValue
VAT rate 0.175
Margin On Cost 0.45

etc.

and then use queries or DLookup() calls to retrieve the values as
required.

These values may be constant in the short term, but are liable to change
over time, so when you are using them in calculations you will probably
want to store them in the "detail" records you are creating, so that the
original calculations can be reconstructed or checked at some time in
the future when the current rates may be different.
 
Back
Top