Querying a Date field

A

Alex Martinez

Hi,

I am using Access 2002 and I want to query a date field called completed.
Now this field may not be populated. How does one query a date field that
is not populated? For example one record has 12/10/05 in the completed
column, which I don't want I only want records that the date field is empty.
Any help will be appreciated. Thank you.
 
F

fredg

Hi,

I am using Access 2002 and I want to query a date field called completed.
Now this field may not be populated. How does one query a date field that
is not populated? For example one record has 12/10/05 in the completed
column, which I don't want I only want records that the date field is empty.
Any help will be appreciated. Thank you.
Click to expand...

As criteria for the [Completed] field"
Is Null
 
Top