Help Again: Need to Count Occurances

[Grammie]

I need a report that looks like this:

1. Number of Enrollees as of Today: (count of everyone in
query){can count last names)

2. Total Active People (count of everyone with "A" as
([Fieldname]=Status))

3. Total Hold People (count of everyone with "HOLD" as Status

4. Total Temporary Suspension: (count of everyone with "TS" as Status

I have a query of everything in table. I have a query that list all
people that are "A". I have a query of everyone that is "Hold". I
have a Query of everyone that is "TS"

I even made a query like this:
Status CountOfStatus
A 1073
HOLD 76
TS 51
But if I put this into the report using sub-report, it shows that
"Status" and "CountOfStatus" thing in the box.

Help. You people are great. I wish the books and tutorials were
helpful.

Blessings,
Grammie

[Dave]

If you have a field named "Status" and its data is one of "A" or "HOLD" or
"TS", try creating calculated field like ABSENT:[Status] = 'A'. Since TRUE
= -1, if you take the negative sum of this, it will count the records with
that status, e.g.

SELECT -Sum([Status]='A') AS Absent FROM tblData

HTH
"Grammie" <bm****@yahoo.com> wrote in message
news:ae**************************@posting.google.c om...

I need a report that looks like this:

1. Number of Enrollees as of Today: (count of everyone in
query){can count last names)

2. Total Active People (count of everyone with "A" as
([Fieldname]=Status))

3. Total Hold People (count of everyone with "HOLD" as Status

4. Total Temporary Suspension: (count of everyone with "TS" as Status

I have a query of everything in table. I have a query that list all
people that are "A". I have a query of everyone that is "Hold". I
have a Query of everyone that is "TS"

I even made a query like this:
Status CountOfStatus
A 1073
HOLD 76
TS 51
But if I put this into the report using sub-report, it shows that
"Status" and "CountOfStatus" thing in the box.

Help. You people are great. I wish the books and tutorials were
helpful.

Blessings,
Grammie