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)
 
Back
Top