ACCESS: Not Null Question

[gheyman]

I want to change this to Not Null from Is Null. Any help is appreciated

TAT: IIf([PDIR Completed] Is Null,DateDiff("d",[PDIR Due Date],[PDIR Completed],"")

Thanks for the help!

 

[xenou]

I think just add the not:

TAT: IIf([PDIR Completed] Is Not Null,DateDiff("d",[PDIR Due Date],[PDIR Completed],"")

 

[gheyman]

What would really help is an "IIF" neither was null then DateDiff("d",[PDIR Due Date],[PDIR Completed]

 

[gheyman]

Thanks Xenou!

And I got the "And" statement

IIf(([PDIR Completed] Is Not Null) And ([PDIR Submission Date] Is Not Null),DateDiff("d",[PDIR Submission Date],[PDIR Completed]),"")