Maybe it's Friday but I have a simple Case statement that doesn't seem to be working and I can't see what's gone wrong!
Here is the statement:
Case(EnjoyScale="Good";1; EnjoyScale="Bad";2; EnjoyScale="Indifferent";3)
The value is for a field called EnjoyScaleNum to give a number rather than the word selected by the entry in field EnjoyScale. They have option to select Good, Bad or Indifferent.
The Case statement returns a 3 for indifferent but when good or bad are entered, the return is a blank cell.
Would be grateful for anyone's help!!