Filter on blank dates

  • Thread starter Thread starter Biggles
  • Start date Start date
B

Biggles

Hi, I want to write a query to filter records where there
is a blank date. What should the syntax be, since the
field is formatted as a date? Using "" does not work.

Thanks
Sean
 
Insert the following in the Criteria: row of the column containing the date
you are testing:

Is Null
 
use is null as the criteria.


Hi, I want to write a query to filter records where there
is a blank date. What should the syntax be, since the
field is formatted as a date? Using "" does not work.

Thanks
Sean
 
Try putting IsNull is your criteria field. The "" is
actually a text string and you want to find an empty
cell, ie., null. HOpe this helps.
 
Try putting IsNull is your criteria field. The "" is
actually a text string and you want to find an empty
cell, ie., null. HOpe this helps.
Click to expand...

Small correction: the critirion should be

IS NULL

with a blank. IsNull() is a VBA function that checks to see if a
variant is null - but won't work as a query criterion. Very easy error
to make!
 
Back
Top