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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

form calculation 7
multiple IIf statement doesn't work - please help 0
historic VAT Rate lookup 10
query too slow 1
possible conflict in coding 1
Calculation Help 1
Decimal places in a temporary table 3
Union query? 7

Back
Top