IIF(EVAL(("valn"+ALLTRIM(STR(mx)))) <> 0,"not zero","zero")or
IIF(VAL(EVAL(("valn"+ALLTRIM(STR(mx))))) <> 0,"not zero","zero")>hi all,
>BROWSE FIELDS ("valn"+ALLTRIM(STR(mx))) >>However this code returns "zero" even though on the row from above i can see the value as 5678. If i do not include the VAL of the string i get an operator/operand tye mismatch error which i through was odd given that the fields are all numeric
>IIF(VAL(("valn"+ALLTRIM(STR(mx)))) <> 0,"not zero","zero") >>any help/pointers much appreciated.