Platform; Windows XP
Microsoft Office - Access 2000
Adapting the example database that was supplied with Access - Northwind Sample Database.
I adapted the above sample database back in 2003 to my own database but have now hit a snag and i am unable to rememberor or find the solution.
Currently, If a product price is amended, then all NEW records will show the amended price but all EXISTING orders prices will remain unaltered, which is fine. However the VAT rate is altering on Monday and if I amend the VAT rate all EXISTING orders aswell as all NEW orders are showing the new VAT rate.
How can I lock the VAT rate on existing orders? ie, using the same principal as the Product Price.
I'm sure the answer is simple but I am struggling to find it
November 28, 2008 6:27 PM
December 1, 2008 9:11 PM