Selecting Blank Records as a option

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

I have a query that is the Row Source for a combo box
that is used to filter a form by date field. Is it
possible to have the query pull only the blank records as
an option? So, the user can see only the records that
have not been resolved yet? If not what would be the best
way to do this?
Thanks in advnace..
 
Do you mean the DateField is Null?

If you do, set the criteria

WHERE DateField Is Null

in the Query being used as the RowSource for the ComboBox.

HTH
Van T. Dinh
MVP (Access)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
I want a blank field in User Form to pull ALL records in a Query 1
Blank fields 3
Return All Record if Check Box is Blank 2
Have both records from two queries/tables under one Query without related fields. 0
In a query, show master records even if a child record doesn't exi 2
query to pull between two dates 4
Parameter Query to filter dates as entered in and if not to show N 4

Back
Top