Date Field Null Values

[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?

 

[Clifford Bass]

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]

Thanks. That did the trick.

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

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?

 

[Clifford Bass]

Hi Steve,

You are welcome!

Clifford Bass