Using Count IF in Report Field

[jereece]

I have a table that includes the following fields

CAUSE_TYPE
STATUS

In a report, I want to count the CAUSE_TYPE if the STATUS is "In Progress". So for example, I want a report that has fields to show

Number of "Root Causes" in progress
Number of "Apparent Causes" in progress
Number of "Common Causes" in progrsss

Can someone help me figure out how to do this?

Thanks,
Jim

 

[Brianwarnock]

I would do the work in the query on which the Report is built

Groupby CAUSE_TYPE Where STATUS is "in progress" and Count your unique key field

Brian

 

[jereece]

Can you give me a few more specifics of how to do this?

Thanks,
Jim

 

[Mikk]

OK, i'd do it this way:

"Count IIf ([status]="In Progress"," ")"

 

[jereece]

OK, i'd do it this way:

"Count IIf ([status]="In Progress"," ")"

Thanks. Just to make sure, this can't be done in a form field...right? It has to be done in a query.

Thanks again,
Jim

 

[jereece]

I get an error message that says "The In operator you entered requires a parentheses".

Your help is appreciated.

Thanks,
Jim

 

[Rich]

=Sum(IIf ([status]="In Progress",1,0))

 

[jereece]

=Sum(IIf ([status]="In Progress",1,0))

That works! Thank you.
Jim