Blanks incorrect

[Lisa]

I am working on a query that will not only tell me if the date is completed
but also forecasted and if forecasted if it is overdue. My issue is all the
blanks are also coming back as overdue can any help me with this issue. I
would like for the blanks to come back with “not date†if possible.

SE Status: IIf(IsNull([Completed_SE Date]),IIf(nz([SE
Date],0)<Now(),"Overdue","Forcasted"),"Completed")

Thank you in advance for any help.

 

[John Spencer]

IIF([Completed_SE] Date is Not Null, "Completed",IIF([SE Date] is Null, "No
Date", IIF([SE Date] < Now(), "OverDue","Forecasted")))


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Lisa]

It works great!!!!!!!!! Thanks

IIF([Completed_SE] Date is Not Null, "Completed",IIF([SE Date] is Null, "No
Date", IIF([SE Date] < Now(), "OverDue","Forecasted")))


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I am working on a query that will not only tell me if the date is completed
but also forecasted and if forecasted if it is overdue. My issue is all
the
blanks are also coming back as overdue can any help me with this issue. I
would like for the blanks to come back with "not date" if possible.

SE Status: IIf(IsNull([Completed_SE Date]),IIf(nz([SE
Date],0)<Now(),"Overdue","Forcasted"),"Completed")

Thank you in advance for any help.