Group Totals Based On Values

[Poida3934]

I am an infrequent access user, and have a totalling problem. I have a query which pulls out a list of students, and the colleges they are going to, as well as their gender (M/F, nothing in between!). I'm trying to produce a report that basically shows me the following, but can't figure out the appropriate function/formula to tally the genders seperately :

Smith College Male : 15 Female : 12
Jones College Male : 11 Female : 9

Totals : Male : 26 Female : 21

Thanks in advance!

[June7]

Options:

1. Use report Grouping & Sorting features: create a group section on the gender field and put aggregate calc in the section footer: Count(*)

2. Use IIf expressions in report footer:

Sum(IIf([Gender]="M",1,0))

Sum(IIf([Gender]="F",1,0))