Counting records from a option group box 1

[webwevers]

Hi, I have a database that has an option group consisting of 3 options, Negative=1 Hit=2 and Blank =3 I am showing all of the records on the report and would like to count only the number of Hit's or value of 2. the report shows the correct check boxes for all of the values. I just would like to only add the Hit check boxes at the end of the report. Thanks for any help.

 

[dhookom]

Add a text box with a control source of:
=Sum(Abs([YourField]=2))

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[webwevers]

Thanks for your help, That worked great!