Query Required to count Data

[Mubashar]

I want to count multiple fields having multiple values in each column. I want to display data like Following pattern:

Data:


Coursecode Gender Response

ACC311	Male	4
ACC311	Female	5
ACC311	Female	4
ACC311	Female	4
ACC311	Female	4
ACC311	Male	5
ACC501	Male	4
ACC501	Female	1
ACC501	Male	4
ACC501	Male	5
ACC501	Female	5
ACC501	Male	1

Required Output:

CourseCode	Total	Male	Female	CQ5	CQ4	CQ3	CQ2	CQ1
ACC311	67	45	22	11	38	7	4	7
ACC501	713	485	228	111	453	48	46	55

There are different courses in which all students (male, female) participated and gave response (1,2,3,4,5).

I want to make summary of each course like in Course ACC311 total 67 students participated, 45 male and 22 Females.. 11 students opted option '5', 38 opted option '4' and so on......

Database.zip

[ranman256]

Make a 'report' table that looks like your final example above.
then make a series of append queries that sum and add to the table.
Then after all have added, the final query will sum the table to 'remove' the blanks and put the rows together.

[Mubashar]

Make a 'report' table that looks like your final example above.
then make a series of append queries that sum and add to the table.
Then after all have added, the final query will sum the table to 'remove' the blanks and put the rows together.

Thanks RanMan for your reply

Are you talking about PivotTable? If yes, than i have tried this but it doesn't work because when i add one more column in data file, the pivotable doesn't work......What kind of append queries you are talking about...Can you explain with example...

Thanks