IIF query?

  • Thread starter Thread starter D
  • Start date Start date
D

D

I have a table w/fields:
PartID
TestDate
TTech
RetestDate
RTech
I want to run a query that will provide the output:
PartID
Technician
FinalTestDate
with the condition that if RetestDate/Rtech are not null
that will be the Technician/FinalTestDate source otherwise
the source is TTech/TestDate.
I am not very good at SQL, can someone help me please?
 
Try something along the lines of

SELECT PartId, Nz(RTech, TTech) as Technician,
Nz(ReTestDate, TestDate) as FinalTestDate
FROM etc

Hope This Helps
Gerald Stanley MCSD
 
Back
Top