how to count Male & Female Student in difference Classes

[phool4fool]

If anyone can help me to figure this out it would be great.

Tables: tblStudents, tblSex, tblGrade, tblClass

Student ID - Auto Number
Student Sex - Text (Male or Female)
Student Grade - Text (A, B, C, D, or E)
Student Class - Text (One, Two, Three, Four, Five)

Now I want to get the following:

Students in Each Class: [ Count how many Students are in Each Class ]
Total Student: [ Count of Total Students ]

Male Students: [Count Male Students]
Female Students: [ Count Female Student"

& I want to do a comparison in a Pivot Chart.
like I want to show male & female student's percentage in a specific class.

 

[Alansidman]

Look here on how to do a aggregate query

http://www.techonthenet.com/access/functions/numeric/count.php

 

[MarkK]

You don't need a tblSex. There are only two. You won't be adding new ones.

 

[phool4fool]

yes it counts but it counts all male & female.
I want to highlight Male and Female Students in a Class as a Pivot Chart.
So how can I get that kind of output.

 

[phool4fool]

You don't need a tblSex. There are only two. You won't be adding new ones.

Sorry I didn't get you.
how can I achieve that output in Pivot Chart to highlight "how many male & female students in a specific class???

 

[MarkK]

Can you post your query text? Have you read the link Alan posted? You need to write a query and then use that query to provide data to your chart.

 

[phool4fool]

Ok Thanks...I've fixed that.