select where field is empty 1

[QuintonV]

Hi ive tried everything I can think of to filter a recordset where a field is empty, ive got various fields like datefields etc.. that have empty fields and dont knowe how to specify a empty clause in my where statement ive tried < &quot;0&quot; or = &quot;&quot; or ='' I also tried &quot; &quot; but non of it works is there a way to search for empty fields?

Thanx

Quinton

 

[piti]

try the IS NULL statement

 

[QuintonV]

Thanx allot thats exactly what I needed