Hi Cindy,

I am kind of new at this, how do I set up a report variable?

Thankyou very much.
Jim

>James,
>
>Set up a report variable nMales to SUM with the expression IIF(Gender = "M", 1, 0) and another report variable nFemales to SUM with expression IIF(IIF(Gender = "M", 0, 1). Set these to group as needed. You may need two sets of variables, one for the class grouping and one for the section grouping.
>
>
>>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