* To have the counts in the same row
SELECT ..., ; 
     Sum( IIF(Genderc="M", 1, 0)) AS males, ;
     Sum( IIF(Genderc="F", 1, 0)) AS females, ...
* To have the counts in the separate rows
SELECT ..., ; 
     COUNT(*) AS males, ;
     ... 
  WHERE Genderc="M" ....
  ...
UNION
SELECT ..., ; 
     COUNT(*) AS females, ;
     ... 
  WHERE Genderc="F" ....

>Hi Group
>
>I have a report from a remote view and all of the fields are grouped.
>
>How do I report the number of females and the number of males takeing class.
>Genderc has values of F and M.
>
>The report breaks down the student body by class and section number.
>
>The number in a section and total number taking class is reproted in the section and class group footers.
>
>Thanks
>Jim