Query a date field

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

Hi All,

I have a table that has a date field. The field gets filled in when that
item is complete (so the record initially exists without a date in it)

I want to query & select all the records that have an empty date field

Thanks

Lee
 
Put the criteria

Is Null

In the "CompletedDate" Column in the Query grid.

HTH
Van T. Dinh
MVP (Access)
 
You must log in or register to reply here.

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

Date search query 0
I want access to fill a field with the current date 4
Adding a field to a subquery 1
Accept date from a form 3
Check if a date exists in a record 1
Using DateAdd and IIF conditions in a Query 2
Finding a year in a date field 2
Date format in Query 1

Back
Top