Solved

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

Posted on 2013-05-17
2
334 Views
Last Modified: 2013-05-17
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
Comment
Question by:pdvsa
2 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 400 total points
Comment Utility
Try this:

"Yes" OR IS NULL
0
 

Author Closing Comment

by:pdvsa
Comment Utility
dang...forgot about that one.  thank you
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Access query grid query 10 20
Query Missing Money orders... 6 62
Dateadd 3 20
Error in SQL Query 36 33
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now