Count only "X" on a Report Header

[Guest]

I have a Text box named ACTIVITY. I the activity could be one of four codes.
B,C,I,X. I would like to count only the "X" and put it on the report header.
How can i do this?

Thanks for your help.

 

[Jim/Chris]

try adding an unbound text box with the control source being
=Abs(Sum([activity]="X"))

Jim

 

[Guest]

Thanks

try adding an unbound text box with the control source being
=Abs(Sum([activity]="X"))

Jim

-----Original Message-----
I have a Text box named ACTIVITY. I the activity could be one of four codes.
B,C,I,X. I would like to count only the "X" and put it on the report header.
How can i do this?

Thanks for your help.
.