Counting "No" Responses from Combo Box

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


"Duane Hookom" wrote:

> 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" wrote:
>
> > 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!
> > --
> > JWeaver

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" <JWeaver RemoveThis @discussions.microsoft.com> wrote in message
news:26D48BFC-59C1-4E82-A366-BC8914CB9752@microsoft.com...
>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!
> --
> JWeaver