How do I display the totals for yes/no responses in a report?

[Guest]

I am producing a report from a database set up to record the responses from
questionnaires. Most of the questions are graded 1 to 5, so its easy to show
an average value; however, on the same questionnaire I have also got yes/no
responses (saved as 1 & 2 respectively). Instead of producing an average
value, I would like to show the total number of replies for each question
(e.g. 5 yes and 4 no).

Many thanks if you can

 

[Rick Brandt]

I am producing a report from a database set up to record the
responses from questionnaires. Most of the questions are graded 1 to
5, so its easy to show an average value; however, on the same
questionnaire I have also got yes/no responses (saved as 1 & 2
respectively). Instead of producing an average value, I would like to
show the total number of replies for each question (e.g. 5 yes and 4
no).

Many thanks if you can

Number of Yes responses...
=Sum(IIf(FieldName=1,1,0))

Number of No responses...
=Sum(IIf(FieldName=2,1,0))