Date Field Null Values

  • Thread starter Thread starter SteveH
  • Start date Start date
S

SteveH

I have a table with two date fields, date created and date completed. I'm
trying to query the table for date completed equals null but it is not
returning any records. The criteria I am using is IsNull([CompletedDate]).
Please, any suggestions?
 
Hi Steve,

Just use "Is Null" in the criteria line of the query designer for that
field's column. In SQL it looks like:

select ... from ... where SomeColumn Is Null;

Clifford Bass
 
Thanks. That did the trick.

Clifford Bass said:
Hi Steve,

Just use "Is Null" in the criteria line of the query designer for that
field's column. In SQL it looks like:

select ... from ... where SomeColumn Is Null;

Clifford Bass

SteveH said:
I have a table with two date fields, date created and date completed. I'm
trying to query the table for date completed equals null but it is not
returning any records. The criteria I am using is IsNull([CompletedDate]).
Please, any suggestions?
Click to expand...
Click to expand...
 
Back
Top