Hi
I am new to Access and hopping someone can help me. I have a query called FreezerSAT1 that we put the date (TDate) we do a test and what equipment ID (TEquip) we used, in another query I have all the equipment ID (InstrumentID) the date (Startdate) the equipment was calibrated and the date(DueDate) when it run out and the correction factor(CT-10). I am trying to make a query that will find the correction factor for the test equipment on the date the test was run. I am not having any luck I am trying to do it with “IIF and” IIF([TEquip]=[InstrumentID] and [TDate]>= [Startdate] and [TDate]<[DueDate],[CT-10],””)
I am new to Access and hopping someone can help me. I have a query called FreezerSAT1 that we put the date (TDate) we do a test and what equipment ID (TEquip) we used, in another query I have all the equipment ID (InstrumentID) the date (Startdate) the equipment was calibrated and the date(DueDate) when it run out and the correction factor(CT-10). I am trying to make a query that will find the correction factor for the test equipment on the date the test was run. I am not having any luck I am trying to do it with “IIF and” IIF([TEquip]=[InstrumentID] and [TDate]>= [Startdate] and [TDate]<[DueDate],[CT-10],””)