The expression IIf(IsNull([ClosedDate]),"Open","Closed")displays ________.
A)Closed when the ClosedDate field has no value and Open otherwise
B)Open when the ClosedDate field has no value and Closed otherwise
C)Closed when the ClosedDate field has no value and nothing otherwise
D)Open when the ClosedDate field has no value and nothing otherwise

Question

Quizplus · Accepted Answer

The IIf function checks if the ClosedDate field is null. If it is null, the function returns "Open". Otherwise, it returns "Closed". Therefore, Option B is the correct answer as it returns "Open" if the ClosedDate field has no value and "Closed" if it has a value.

The Expression IIf(IsNull([ClosedDate]),"Open","Closed")displays ________