Filtering records in a report

[Guest]

Hi,

I have a query which lists answers to 25 questions from a survey. The
Answers are True, False and N/A. The query lists any individuals that have
answered False or N/A for any of the 25 questions.

I want to produce a report to show the Indivduals name and then list which
question numbers they answered False or N/A to. I do not want the report to
show any questions that were answered as True.

I have tried using an iif Statement but do not know how to use multiple iif
statements. I'm not even sure that this is the easiest route to go.

Any help would be much appreciated.

Many thanks

 

[Guest]

Hi.
What about using a query where you simply set the condition of the response
to <>"true" or <> "Yes", which format you use will depend on what you have in
your table.
Hope this helps.
Fons