Solved

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

Posted on 2013-05-17
2
343 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
ID: 39175085
Try this:

"Yes" OR IS NULL
0
 

Author Closing Comment

by:pdvsa
ID: 39175125
dang...forgot about that one.  thank you
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
zero pad a access form field 2 16
Search for text in a .txt file 14 44
Question about DB Schema 27 56
split XML field into many fields from MS Access 21 20
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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…

772 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