Report: Selective Counting

[mercy]

I'm setting up a Database for employees. Some are Full Time others Part Time. My Report lists employees by Department and shows their status (Full time or Part Time).

I want to be able to count:

1) all personnel in the Department
2) only those in the Department who are Full Time
3) only those in the Department who are Part Time.

To count all personnel is not the problem. I use the following:
=Count([StaffStatus])

To do a selective count is the problem. I've tried the following: =Count([StaffStatus]="FullTime&quot
=Count([StaffStatus])-Count([StaffStatus]="PartTime&quot

These don't work for me. They count the total entries, regardless of whether they are Full Time or Part Time.

I put the "count" code in the Sector Footer of the Report

Please Help!

 

[moedweck]

You can put an unbound control at the sector footer of the report and put a SQL statement in the Control Source of that control that would do a DCount on records from the table that have a criteria of StaffStatus="Full Time".

It would read something like:

= DCount("[StaffStatus]", "Table Name", "[StaffStatus]='Full Time'&quot

This should do it.

Moe Dweck
Data-trieve, Inc.

 

[Guest_imported]

Another way to accomplish this is to put the folllowing code in the Control Source for your three count Textboxes.
=Sum(IIf([StaffStatus]="FullTime",1,0))
=Sum(IIf([StaffStatus] = "PartTime",1,0))
=Count([StaffStatus])
The Sum of 1's produces the same value as Count.
Paul

 

[mercy]

Thanks a million, you're both stars.

Nik