Query an entire table

[Guest]

I have created fairly large table to gather hospital audit information. The
audit has 70 questions per unit. The questions have a Yes, No or N/A value.
I need to create a report that will give me only the No values. Creating a
query with No in the criteria is not going to work since not all the
questions will have a No response. Is there a way to query the entire table?

I hope that makes sense.

Btw- I’m a self taught access user, so I’ll try to keep you with anyone who
has any suggestions.
Thanks for your help.

Linda

 

[Guest]

It sounds like your data is like below. If it is then it needs to be revised
to be like the second dataset.
Unit Question_1 Question_2 Question_3 Question_4 Question_5 Question_70
1 Yes Yes No Yes No Yes
2 Yes No Yes No Yes No
3 No Yes No No No Yes
4 Yes No Yes No Yes No
5 No Yes No Yes Yes Yes



Unit Question
1 1 Yes
2 1 Yes
3 1 No
4 1 Yes
5 1 No
1 2 Yes
2 2 No
3 2 Yes
4 2 No
5 2 Yes
1 3 No
2 3 Yes
3 3 No
4 3 Yes
5 3 No
1 4 Yes
2 4 No
3 4 No
4 4 No
5 4 Yes