Thanks Sergery!



>

* 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