Filtering records in a report

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

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
 
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
 
Back
Top