If then else statements in sql

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_Fille d,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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Akilah" wrote in message
...
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_Fille d,Date())) AS
No_Working_Days, ( IIf(IsNull(projects.date_filled),'Not filled',' ') ) AS
Message
FROM Projects;

Thanks,
Akilah