Tabulating results from a Likert scale

[technoranger]

Maybe I designed this wrong....I have a database of survey results. 10 questions (fields), each pulling from a value list (SA, A, N, D, SD) displayed as radio buttons. I would like to calculate the number of responses per field, e.g. for question 1, how many respondents answered SA versus A versus N, etc.

It would be easy if I had 50 fields (1SA, 2SA, etc.) but it seems like there should be a way to calculate the count of Field 1 equalling SA, etc.

Any thoughts?

Rick Metheny