Problem with my report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DDR - 30 Dec 2005 15:01 GMT

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")

Reply to this Message

Duane Hookom - 30 Dec 2005 15:21 GMT

=Abs(Sum([EmploymentStatus]="Active") )

Signature

Duane Hookom
MS Access MVP
--

>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
[quoted text clipped - 5 lines]
>
> =Count([EmploymentStatus]="Active")

Reply to this Message

TedMi - 30 Dec 2005 20:21 GMT

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

Signature

Ted

Reply to this Message

Duane Hookom - 30 Dec 2005 20:36 GMT

I'm not sure how you would implement a sql statement in the control source
of a text box.

Signature

Duane Hookom
MS Access MVP
--

> 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

Reply to this Message