count

[sadie]

I have a report based on a query as to my studen't age,gender, etc.
How can I count certain things in a field such as in my Gender field, count how many males and how many females

 

[Jesmine]

SELECT COUNT(ID) AS [Females Number]
FROM MyTable
WHERE Genger ="Female"


CELECT COUNT(ID) AS [Males Number]
FROM MyTable
WHERE Gender = "Male"


Good Luck!

Zena