IIF query?

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?
 
G

Gerald Stanley

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
 
Top