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.