By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,054 Members | 1,635 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,054 IT Pros & Developers. It's quick & easy.

Help Again: Need to Count Occurances

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.