Forum Discussion

Copper Contributor

Nov 06, 2024

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...

Iron Contributor

Nov 07, 2024

maybe try:

SELECT Init_Static_P, 
            Adj_Static_P, 
           Switch(Nz([Init_Static_P],0)>0,"Not Resolved",Nz([Init_Static_P],0)<=0,"Resolved") AS Result
FROM YourtTableName;