Count only "X" on a Report Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
try adding an unbound text box with the control source being
=Abs(Sum([activity]="X"))

Jim
 
Thanks

Jim/Chris said:
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.
.
Click to expand...
Click to expand...
 
Back
Top