queries

[snakedog]

Hi all I have a question that I hope someone can answer, I have
reports pulling in 1,-1,0 all is good everything is working like I
want it too, but here is my problem.

I want a report that only pulls the -1 and nothing else. How can I do
that?

Here is an example
order 123 has 10 questions the report looks like:

orderid date question 1 question 2 question3 ?4 ?5 ?
6 ?7 ?8 ?9 ?10
123 08/15/200 1 0 1
-1 1 -1 -1 0 -1 0


Now I want a report that shows me only the -1 for example
orderid date ?4 ?6 ?7 ?9 total
123 08/15/200 -1 -1 -1 -1 4
or something like that as long I can see per day or week or month all
answers that were selected with the -1 value..

any help would be greatful.

 

[Guest]

You could base the report with the field criterias set to -1 or apply a
filter via a open report button