I am trying to use the field calculator to assign a "odd" or "even" value to a field of small integers. I usually do this with by selecting where:
MOD([field],2) = 0
and then just calculating it as "even", then reversing the selection and setting it to "odd"
I was hoping to do something like this in the field calculator:
DIM oddeven IF mod([Field],2) = 0 oddeven = "even" else oddeven = "odd" end IF
This does not work and I assume there is an alternate use of the mod() in this setting, or perhaps you cannot use an operator in the IF/THEN condition statement. Any ideas would be appreciated! Thanks.