place holder for zero count

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Seren - 27 Oct 2005 19:51 GMT

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

Reply to this Message

Seren - 28 Oct 2005 18:05 GMT

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?

> 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
[quoted text clipped - 8 lines]
> Thanks!
> Seren

Reply to this Message