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

You can do this with a subsummary part, sorted by the field.

EG. Field 1 contains SA,SA,A,N,N,N

On the summary report add a subsummary part for sorted by field 1. Then, on that part add the field and also a summary field [count field one].

You don't need a body part, just the sub summary.

Then, when you preview this report and sort based on that field it will count all occurrences of the items and give you a total.

EG.

Field 1 A Total 1

Field 1 N Total 3

Field 1 SA Total 2

Not sure how it would look for all the fields.

HTH or at least gives you a new direction.