place holder for zero count

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

Guest

Ok, I've got a query that counts how many times a response in an option group
was given. I'm having a couple of issues with this (see "query headings out
of order" for my other issue) The queries are used for a summary report.
One query, for example, will say "Yes" 3 "No" 2, meaning, of course, that 3
respondants answered yes and 2 answered no. My problem is that if 0
respondants answered No, it leaves off the heading and everything. Is there
a way I can get it to specifically state that 0 people answered no?

Hope this makes sense. Any help would be appreciated!

Thanks!
Seren
 
I feel like I'm getting closer, but would still appreciate some help. I'm
not sure if I'm on the right track here, but this is what I've come up with
so far...

In the subreports in the properties list for control source, I was using
=IIf([CountOfoptExpediteOrders]=0,"0",[CountOfoptExpediteOrders])

What this says to me is if the field equals 0, enter 0. Otherwise, enter
the count of the field. However, what this is doing is placing "Name" in as
the result. There is nothing in my queries or tables with a name or value of
Name. What is this? Also, this isn't placing it where I need it to go.
It's creating it's own column w/o a header and just putting the result. So,
instead of it saying 0 100%, 1 90%, 0 75%, etc, it leaves me with 0, 1 90%...
or actually, due to the result problem, it is Name, Name 90%.

Suggestions? Please?
 
Back
Top