R
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.
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.