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