Counting "No" Responses from Combo Box

  • Thread starter Thread starter JWeaver
  • Start date Start date
J

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!
 
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"))
 
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."
 
Thanks, Duane! That worked!!!
--
JWeaver


Duane Hookom said:
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


JWeaver said:
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!
Click to expand...
Click to expand...
 
Back
Top