rsingh4377
Registered User.
- Local time
- Today, 15:59
- Joined
- Jun 17, 2019
- Messages
- 39
I am creating a query for several fields of data. My current criteria is as follows: ([Forms]![Formname]![labelname]). So this criteria goes on for several fields of information and in the end I linked this to a form which will display information in a query search based on the selections on the form by pressing a button. Each field has a yes/no combo box. Now the problem is that when I use AND to separate each criteria in sql, it displays information only for those that values are yes in only those fields. For example, If I am looking for certain names of parks and search for parks with biking lanes and free parking with a yes value and put a no value for basketball courts because that is not what I am looking for, then the query shows only parks with those two yes value and assumes that I am looking for parks without basketball courts when in fact I DO NOT want the no value to have an impact on the result. I want the query to display information based on the yes values with the no value having no impact on the result. I feel like I'm missing something very basic here so please help. If any clarification is needed then please let me know! Also using OR to separate each field does not work because it takes into account the no values and ends up displaying ALL the results.