ACCESS: Not Null Question

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,690
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

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,587
Office Version
2013
Platform
Windows
I think just add the not:

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

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,690
What would really help is an "IIF" neither was null then DateDiff("d",[PDIR Due Date],[PDIR Completed]
 

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,690
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]),"")
 

Forum statistics

Threads
1,085,905
Messages
5,386,694
Members
402,011
Latest member
yousraemara

Some videos you may like

This Week's Hot Topics

Top