Date Field Null Values

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

"SteveH" wrote:

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?

Thanks. That did the trick.

"Clifford Bass" wrote:

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" wrote:

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,

You are welcome!

Clifford Bass

"SteveH" wrote:

Thanks. That did the trick.