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

You might also completely dispense with the case calculation and look up the number values from a table of part numbers. This can be a much more flexible approach--especially if you find that you need to update such a list of part numbers or the values associated with them.