Query a date field

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
 
V

Van T. Dinh

Put the criteria

Is Null

In the "CompletedDate" Column in the Query grid.

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

Date search query 0
Query to list records that don't match 6
Accept date from a form 3
Adding a field to a subquery 1
Query incorrectly reporting a value as null 9
I want access to fill a field with the current date 4
Using DateAdd and IIF conditions in a Query 2
Make a Date Field Autopopulate 6

Top