Counting "No" Responses from Combo Box

[JWeaver]

I have a report that I need to tabulate the number of "No" responses to
several combo boxes. I tried Count function but it totals all of them and
not just the ones I want.

Many thanks!

 

[Duane Hookom]

You can enter a control source in a text box in most header and footer
sections like:
=Sum(Abs([SomeField] = "Some Value"))
For instance to count the number of records in your report where Gender =
"F", your control source would be:
=Sum(Abs([Gender] = "F"))

 

[Al Campagna]

JWeaver,
I think we'll neeed a bit more detail as to what your trying to do.
Could give us an abbreviated example/sample of what your report
delivers? "What you have now" versus "What I'd like to see"
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[JWeaver]

Thanks, Duane! That worked!!!
--
JWeaver

You can enter a control source in a text box in most header and footer
sections like:
=Sum(Abs([SomeField] = "Some Value"))
For instance to count the number of records in your report where Gender =
"F", your control source would be:
=Sum(Abs([Gender] = "F"))

--
Duane Hookom
Microsoft Access MVP

I have a report that I need to tabulate the number of "No" responses to
several combo boxes. I tried Count function but it totals all of them and
not just the ones I want.

Many thanks!