4 Replies Latest reply on Jan 2, 2012 11:03 AM by mikefromnewmexico

    CASE FUNCTION RECEIVING ERROR "AN OPERATOR IS REQUIRED..."

    mikefromnewmexico

      Title

      CASE FUNCTION RECEIVING ERROR "AN OPERATOR IS REQUIRED..."

      Post

      Happy New Years!

       

      I am running a case function in for a field that receives an error once I get t a certain point in it. Everything is fine until I get to "7" and then it won't let me go further.

      It will highlight the part number for "OTHER" (as I've changed text color below) and then give the error code. Ideas? Thanks in advance

      Case (
      Part Number = "1ask5" ; "1";
      Part Number = "FDSY7" ; "2";
      Part Number = "5200D4" ; "3";
      Part Number = "XXLTULT" ; "4";
      Part Number = "SIMPM4D" ; "5";
      Part Number = "CTN" ; "6";
      Part Number = "FSDLKO" ; "7"
      Part Number = "OTHER" ; "8"
      )

       

      The reason I am using the case function is to allow a simple numeric sort. I have deleted the field and re-created it from scratch with no luck