This content has been marked as final. Show 7 replies
I think you need to add at the top of your code a simple dim statement like:
Also not sure this line is correct:
ElseIf [CLASSIFICATION_1] = "<null>"
you may want to try something like (I did not test these):
ElseIf [CLASSIFICATION_1] = ""
ElseIf IsNull([CLASSIFICATION_1]) = True
Hhmm I have added Dim x at the top and changed that one line to be ElseIf IsNull([CLASSIFICATION_1]) = True then.... However its still not working. But I am getting a new error, which says "Error Executing Funtion. Expected 'Then' Failed to execute".
Thanks for the help! any other ideas?
Can you post up the script, exactly how you entered it?
If [CLASSIFICATION_1] = "High" then
ElseIf [CLASSIFICATION_1] = "Medium" then
ElseIf [CLASSIFICATION_1] = "Low" then
ElseIf IsNull [CLASSIFICATION_1] = True then
x = 9999
Thanks for your help!
"EndIf" needs a space ---------> "end if"
Also, IsNull is a function, and requires ()'s around the field name.
This is going to be painful...
should be (note space)
You guys are BRILLIANT !!
Both the space was required and the ()'s after IsNull.
Thank you so much!