Query an entire table

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

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