counting the records

[rick]

I have a report that uses the SQL Statement:Query Builder to pull in the
data.
The report returns a list of employees sorted alphabetically, grouped by
Type, and lists the following field names; type, name, division and time
In the report footer I would like to add a text box to count the only
employees who meet a certain criteria in three of the fields. I know this
doesn't work but I it shows what I'm attempting to return:
Count([Type]="DR" & [Division]="C" & [Time]="Full")

Thank you for reading and considering my post. Any help is most
appreciated.

 

[tina]

you're close. try

=Sum(IIf([Type]="DR" And [Division]="C" And [Time]="Full", 1, 0))

hth