The field value choices are: Agree, Somewhat Agree, Somewhat disagree, Disagree
I want to assign the following numeric values to each choice:
1 -Agree
2 -Somewhat Agree
3 -Somewhat Disagree
4 -Disagree
I'm guessing I need to insert a column in my query and enter some kind of formula. It seems simple, but it is evading me.