• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

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

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

Query
0
pdvsa
Asked:
pdvsa
1 Solution
 
mbizupCommented:
Try this:

"Yes" OR IS NULL
0
 
pdvsaProject financeAuthor Commented:
dang...forgot about that one.  thank you
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now