counting multiple columns in a query (1 Viewer)

[m9jiihmr@gmail.com]

Student ID
Command over subject
Teaching Subject
Explaining things
Pedagogy Methods
Solicited_Participation_Class
1
Good
Average
Bad
Good
Bad
2
Bad
Average
Good
Bad
Good
3
Average
Average
Average
Good
Average
4
Average
Good
Good
Average
Average
5
Average
Average
Bad
Average
Good
6
Good
Average
Average
Good
Bad
I have a table given above, table name is student. Which has following sample data.



I want to count the no. of students who say Good, Average ,Bad for every indicator
Output from query:

Good
Average
Bad
Command over subject
2
3
1
Teaching Subject
1
5
0
Explaining things
2
2
2
Pedagogy Methods
3
2
1
Solicited_Participation_Class
2
2
2

How this can be achived from query in MS Access 2010
Thanks a lot
Manoj

 

[m9jiihmr@gmail.com]

Dear Listers

[FONT=&quot]I attached my query in image file.
Please see. I think MS Word table is not supported here.

Thanks
Manoj
[/FONT]

 

[Guus2005]

A picture says more than a thousand words. thanks for that.

You want to use values as column names.
You can accomplish that using a crosstab query.

Look in the access help files.

Let me know if you need help with that.

HTH
Guus

 

[m9jiihmr@gmail.com]

Hi
Thanks for your mail.
I never worked on crosstab query using Access.

If you can help me in my query, would be grateful.

Thanks and Regards
Manoj

 

[Minty]

Experiment - you won't break anything.

Open the query editor select your Student table. Select the fields you want to see.
Change the query type to crosstab make the Student ID the Column heading, then experiment with the others as row headings, and values. You will quickly see how it works.