Converting Likerrt Scale to Values and Calculating Average

[snubee]

I'm working on a database after not having done anything in Access for over five years so I've forgotten most everything.

I have a survey that uses a likert scale of Strongly Agree, Agree, Neither Agree, Disagree, and Strongly Disagree. I want to convert these to numerical values 1-4. Then I want to calculate the average score for the whole survey in the report.



How do I convert these to numerical values in a report? I researched how to average and it is telling me to go to the Design tab and the Grouping and Totals group, but when I go to the Design Tab in Layout I do not see a Grouping and Totals option anywhere.

[June7]

Options:

1. lookup table with the numeric values, include table in query - really should have been saving the numeric values to begin with then convert to descriptors

2. calculate with expression in query: Switch([fieldname]="Strongly Agree", 1, [fieldname]="Agree", 2, [fieldname]="Neither Agree Nor Disagree", 3, [fieldname]="Strongly Disagree", 4)

then use field with Avg() function in textbox on report