Counting responses to Combo Box

[lwienke]

I have a combo box on a form where you can choose Very Satisfied, Satisfied,
Somewhat Satisfied, or Not applicable. On my report I want to put the number
of Very Satisfied responses, Satisfied responses, etc. I have created a
crosstab query for each of the questions and the query shows the responses,
but what is the expression that should be put in the report control source to
count the responses?

 

[KARL DEWEY]

Why are you not using the crosstab to count?

 

[lwienke]

I must be missing a step - it's been a while since I used this piece - The
crosstab query shows the responses for each record in the column (i.e. Very
Satisfied, Satisfied, etc) there is no total for each column. On my report
(which is a summary of all the questions on a survey) I want to put the total
of each column in a control next to each response.

Very Satisfied 3 Satisfied 4 Somewhat Satisfied 2

Thanks for trying to help

 

[KARL DEWEY]

Your crosstab should give this as output ---
X Question Very Satisfied Satisfied Somewhat Satisfied
0 1 3 4 2
0 2 0 5 4
0 3 2 3 4
This is done by adding another row header in the query.
Like this --
SELECT 0 AS X, Question
FROM ...

Then in the report use Grouping and Sorting and have header and footer for
group 'X'. In the footer put a textbox with running sum for each response
type.