Help!!!!

[Jesmine]

Help about counting!!!!

Hello,

I have students table and I want to make one report that gives me the number of males and females,
is that possible???

Thx in advance

Zena

 

[RichO]

This is assuming you have a field [Gender] that specifies gender:

I would suggest to start with a simple totals query:

SELECT Count(*) AS GenderCount, MyStudentTable.Gender
FROM MyStudentTable
GROUP BY MyStudentTable.Gender;

And then write a report based on that query.

 

[Jesmine]

thx

Thank you RichO...
your simple totals query fixed my problem...
once again thank you very much

Zena