Counting in a Report

[Aurora]

I am using Access 2003
I have a report that is sorted by [Name], then [project #], then [status]
such as "Very good", "Progressing Nicely", "Not good progress" etc. I want
to be able to count how many of each "Status type" each person has. Ex:
John doe has 10 projects and 2 of them are Very good, 7 are Progressing
Nicely and 1 is not good.

I can count the projects with a simple count(*) function. I know I have
counted sub groups before, but can't remember how I did it. I believe that
somewhere in the header I put a formula that said "something = 1" and change
the properties to hide this formula. But I can not remember what I did. Can
anyone help me please? or at least point me in the right direction.

thank you - aurora

 

[Duane Hookom]

If your status options WILL NEVER CHANGE, you can use text boxes in report or
group footers or headers with control sources like:
=Sum(Abs([Status]="Progressing Nicely"))

If you want these all grouped together, you are much better off creating a
totals query that groups by employee and status while counting the records.
Use this totals query as the record source for a subreport in the Employee
header or footer section.