Blanks incorrect

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

Guest

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.
 
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
..
 
It works great!!!!!!!!! Thanks

John Spencer said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top