Forum Discussion
MS Access Handling Nulls In Query Formula
Hi all, I have this formula in Access: IIf([Init_Static_P] < 0 And (Nz([Adj_Static_P], -9999) < 0), "Resolved", "Not resolved" which keeps outputting an #Error when Adj_Static_P is null which wil...
I guess your example output isn't representative or complete, as you can ignore Adj_Static_P:
IIf([Init_Static_P] > 0, "Not resolved", "Resolved")