Jan, add a field to this table to hold the tax rate: Number, size Double,
If you could ever need to cope with some items of an invoice being
tax-exempt, you will want to do this in the detail table. You will then use
a query as the RecordSource of your form, with a calculated field such as
Tax: [Quantity] * [UnitPrice] * [TaxRate]
You can use an Update query to populate the new field with 0.05% for all
You can store the TaxRate in a table, DLookup() the current rate in the Open
event of the form, and assign to the Default Value of the text box.
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.