A bit of a weird request, I hope I can word it correctly. Basically I want a query that returns values for a row only where some parameters are met, but each one is separate from the other.
So in my table, each record relates to an agency. And that row shows how that one agency did on several yes/no questions. If they got a 'no' on question 1, then I want the query to return both the field that says 'no', AND the field to its right where the staff would write 'notes'. So the query essentially will provide a list to staff on only questions that the agency failed, and the notes that were given for that question.
The issue I'm running into is that each question is separate of each other, and so when I write in my criteria to only return values where the answer is 'no', I can only do that once before it will return nothing. Only records where an agency got a 'no' on every answer will be returned because the query is being literal. I tried putting it in the 'or' section of the query design but I might be doing that wrong.
Any thoughts or guidance? Below a segment of the SQL code, stopped after 2 questions because it's a massive query (but repetitive).
SELECT OperationalReviews.Provider, OperationalReviews.OpReviewYear, OperationalReviews.OpReviewStarted, OperationalReviews.OpReviewClosed, OperationalReviews.OpQ1YesNo, OperationalReviews.OpQ1MinutesDate, OperationalReviews.OpQ1Comments, OperationalReviews.OpQ1ActionTaken, OperationalReviews.OpQ1DateClosed, OperationalReviews.OpQ2YesNo, OperationalReviews.OpQ2Comments, OperationalReviews.OpQ2MeetingDate1, OperationalReviews.OpQ2MeetingDate2, OperationalReviews.OpQ2MeetingDate3, OperationalReviews.OpQ2MeetingDate4, OperationalReviews.OpQ2ActionTaken, OperationalReviews.OpQ2DateClosed, OperationalReviews.OpQ3YesNo, OperationalReviews.OpQ3Comments, OperationalReviews.OpQ3ActionTaken, OperationalReviews.OpQ3DateClosed, OperationalReviews.OpQ4YesNo1, OperationalReviews.OpQ4YesNo2, OperationalReviews.OpQ4Comments, OperationalReviews.OpQ4ActionTaken, OperationalReviews.OpQ4DateClosed, OperationalReviews.OpQ5YesNo, OperationalReviews.OpQ5YesNo2, OperationalReviews.OpQ5Comments, OperationalReviews.OpQ5ActionTaken, OperationalReviews.OpQ5DateClosed, OperationalReviews.OpQ6YesNo, OperationalReviews.OpQ6YesNo2, OperationalReviews.OpQ6Comments, OperationalReviews.OpQ6ActionTaken, OperationalReviews.OpQ6DateClosed
FROM OperationalReviews
WHERE ((Not (OperationalReviews.OpQ1YesNo)="Yes - Pass"));
Thanks!
A