By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,806 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Show the NO answer only

P: 69
Am stumpped.

I have a query that has Q1, Q2, Q3, Q4. Each one of these have a question associated with it. Each question has the YES or NO option to select from.

Is there a way to see only those answers that have a NO?

You see, I am attempting to create a report and show only those questions where they answered with a NO.

Thank you VERY MUCH for your time and assistance.
Aug 25 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
In the Query Grid you need to set the Criteria for a given question to No. If the field is defined as Text, and the users actually enter the word "No' you need to use the Criteria of "No" with the quotation marks. If the question field is defined as a Yes/No field, the Criteria would be No, without the quotation marks.

Linq ;0)>
Aug 26 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.