Help with qry

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

Guest

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?
 
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"
 
Back
Top