S
smason
Hello
i have a qry which runs from an applicant tbl etc with results like this
name surname datein grosspay vat (is default)total(grosspay
+vat)
john smith 01/01/2007 £1000 17.5 1175.00
i work out the total via the query but the problem is if for argument sake
the vat changes to say 20% all my historical data will change to 20% and not
keep the 17.5 that it is now! how can i do this so the historical data remains
i have a qry which runs from an applicant tbl etc with results like this
name surname datein grosspay vat (is default)total(grosspay
+vat)
john smith 01/01/2007 £1000 17.5 1175.00
i work out the total via the query but the problem is if for argument sake
the vat changes to say 20% all my historical data will change to 20% and not
keep the 17.5 that it is now! how can i do this so the historical data remains