Is this possible

[markjeff]

I'm working with this query

SELECT EmpInfo.LoginID, EmpInfo.LName, EmpInfo.Fname, EmpInfo.Dept, Min(Sicktrack.[Sick Date]) AS LastDaySick, EmpInfo.Sup, EmpInfo.HireDate
FROM EmpInfo LEFT JOIN Sicktrack ON EmpInfo.LoginID = Sicktrack.LoginID
GROUP BY EmpInfo.LoginID, EmpInfo.LName, EmpInfo.Fname, EmpInfo.Dept, EmpInfo.Sup, EmpInfo.HireDate;

It possible for this ((Sicktrack.[Sick Date]) AS LastDaySick)to return no value. When this field is null I want it to defualt to EmpInfo.HireDate.

I've been working on this for a few hours and I'm getting no where

 

[markjeff]

Nevermind I Figured it out using an IIF

 

[namliam]

You are looking for the function NZ actually... check it out in the help...