Checking for empty date field

[davesmith202]

I can check using Is Null as a filter but what about if someone has previously entered a date but then deleted it? It won't be a null. So, what criteria would I use to check for that in my query?

Thanks,

Dave

 

[RainLover]

Use LEN

If Len(FieldName) = 0 then etc

Len equals Length.

 

[davesmith202]

I can use that in the QBE grid? I need the filter for the query and not a vba created query.

 

[RainLover]

Sorry about that I did not realise you were using a query.

Try
NewField:Len(FieldName)

Criteria > 0

 

[davesmith202]

Ahhh thats a good idea! Thanks Rain.

 

[RainLover]

Jon

Happy to help.