Count on a report when a field =x

[mlocurci]

I have a report where I count the amount of records, no problem there. I now need to count how many time a record =x.

I have a field called [client]. It can equal BN or fb.

I need to count it when its BN and when its fb, any ideas

 

[JerryDennison]

Place two unbound controls in the report footer and use the following syntax for each:

=Count(IIF([FieldName] = "BN", [FieldName], Null))

=Count(IIF([FieldName] = "fb", [FieldName], Null))

 

[mlocurci]

OMG that helped so much!

 

[JerryDennison]

You're welcome.