Hi all, I am trying to do a very straightforward (or so I thought) query that changes any value with an error to 0. But the IsError() function is itself returning "#error" instead of returning true. Any insight on this?
query sql:
returns:Code:SELECT DataCalcQ.LineItemID, DataCalcQ.DV, IIf(IsError([DV]),0,[DV]) AS NewDV FROM DataCalcQ;
LineItemID DV NewDV 6161 0 0 6162 2513 2513 6163 2557 2557 6164 1092 1092 6939 2903 2903 6940 2903 2903 6941 2600 2600 6974 #ERROR #ERROR 10029 #ERROR #ERROR