<div>
dang...forgot about that one. &nbsp;thank you
</div>


dang...forgot about that one.  thank you

<div>
<div class="content wysiwyg-content">
I have a combo box with a value list =&quot;Yes&quot;;&quot;No&quot;, text property<br />
<br />
i need to remove the records with &quot;No&quot; in the query<br />
I put &lt;&gt;&quot;No&quot; in the criteria of the query but it removes the nulls as well. <br />
I have tested many ways but I guess I am not doing something right. <br />
<br />
How can I display only the &quot;yes&quot; records and the nulls? &nbsp;<br />
<br />
thank you<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/05_w20/655039/untitled.JPG" target="_blank" title="Query (11 KB)"><img alt="Query" class="file-block lazyload" style="max-width: 370px;" data-src="https://filedb.experts-exchange.com/incoming/2013/05_w20/655039/untitled.JPG" /></a>
</div>
</div>


untitled.JPG

I have a combo box with a value list ="Yes";"No", text property

i need to remove the records with "No" in the query
I put <>"No" in the criteria of the query but it removes the nulls as well. 
I have tested many ways but I guess I am not doing something right. 

How can I display only the "yes" records and the nulls?  

thank you



combo box, value list: &quot;Yes&quot;, &quot;No&quot;, remove &quot;No&quot; in query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

combo box, value list: &quot;Yes&quot;, &quot;No&quot;, remove &quot;No&quot; in query

combo box, value list: "Yes", "No", remove "No" in query