If then else statements in sql

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want my query to return a message based on the input received. How do I
make this statement return a message to the same column

( IIf(IsNull(projects.date_filled),'Not filled',' ') ) AS Message

I want to be able to return a different message if the projects.date_ filled
is not null.

Here is the complete code:

SELECT Projects.Project, Projects.Position, Projects.Date_Open,
Projects.Date_Filled, Projects.Recruiter,
nz(Int(Projects.Date_Filled-Projects.Date_Open),0) AS Time_to_Fill,
Workdays(Projects.Date_Open,nz(Projects.Date_Filled,Date())) AS
No_Working_Days, ( IIf(IsNull(projects.date_filled),'Not filled',' ') ) AS
Message
FROM Projects;

Thanks,
Akilah
 
You should be able to return text like this:

IIf([projects].[date_filled] Is Null, "Not filled", "Filled") AS Message
 
Back
Top