search for all blank (null entry) entries in a date field 1

[loganswell]

Hi!

Can anyone tell me what to place in a date field in my Access Query (design view) so that it will show all records in the database where a date field has been left blank? I tried ="" but that didn't work (as I suspected)!

Thank you! )

 

[rjoubert]

Try "Null

 

[jebry]

Hi!

On the Criteria line put Is Null

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[rjoubert]

If you type in "NULL", it automatically changes it to "Is Null