How to get multiple running selective counts?

[asp3232]

Hi,

I've got a report that's almost where I need it to be, but need some summary information on it that I'm not sure how to accumulate. Here's the situation:

I've got multiple Organizations (I'll use 2 for simplicity -- call them AA and BB), each with Divisions (call them A and B). Each of the Divisions has projects, and each project has a status of Red, Yellow, Green, or White.

I can get the report groupings to work out just fine, but what I'm after is a total for each Division and Organization for the number of projects with each status.

I haven't found anything that looks very promising so far...

Any thoughts?

Thanks!

asp

 

[flaniganmj]

In whatever section/report footer, in a text box use:

=Count(IIf([Status]="Red",[Status]))

This should work fine. You could also you the DCount function. Assuming you don't have many statuses, just create a text box for each.