Help with qry

S

StuJol

i have a qry and one of the fields are set to:

VAT: IIf(DLookUp("[VAT]","tblOurCompanyInfo")=1,(([SubTotal]/100)*17.5),0)

Currently this field is global, so i could have 100 records without VAT and
if i were to select include VAT from my setup form, all 100 records
(historical records) would then change to include VAT.

Is there a way to have this statement apply to new records only within the
qry and to leave all old records alone?
 
J

John Spencer

Do you have a datetime field or other method that tells you which records
are "old"? If so, you can use the field or fields to determine whether or
not to do the calculation.

It would be better if you could adjust the subTotal field on the old records
so that you wouldn't have to worry about doing a special calculation based
on whether or not a record was "old"
 
Top