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