• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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