Querying a Date field

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
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.
 
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
 
Back
Top