record counts

[Newbie]

I am trying to do multiple record counts within a group. For example, I want
to count on two of my sorts within my grouping. It appears that I cannot do
that because the count function does not let me specify a parameter - for
example, I want to count all my records within a group that have a specific
city as a value in the city field.

 

[Steve Schapel]

Newbie,

Something like this:

=Sum(IIf([City]="Specific City",1,0))