Problem with my report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am sure this is an easy question for most people, but I can't seem to
figure this out. I am running a report and would like to count the
specific number of people with a given status. My report lists 248
people that I work with, and their statuses are either Temporary or
Active. How do I create a count function that will give me only the
active employees at the end of a report. Here is the expression I have
been trying to use, but it has been unsuccessful.


=Count([EmploymentStatus]="Active")
 
Much more intuitive:
=Count(*) Where EmploymentStatus="Active"
This formulation does not depend on the obscure knowledge that a true
comparison returns a value of negative 1
 
I'm not sure how you would implement a sql statement in the control source
of a text box.
 
Back
Top