Problems - Query does not filter blank fields with IS NULL

M

Maik

Hi there,

I´ve an Access table and a query which should filter all those records
which have blank fields. As criteria I specified IS NULL for this
column, e.g. WHERE Feld IS NULL..

The scary thing however is that do not get any results even though
there are blank fields in there. For some other queries it works fine.
What could be the problem? Formats maybe?

Thanks,
Maik
 
N

Nikos Yannacopoulos

Maik,

It may be that the field contains a zero-length string ("") instead of
being bull, which you cannot tell by looking at the table, they look
just the same. Try this variation if your WHERE clause:

WHERE ((Field IS NULL) Or (Field = ""))

HTH,
Nikos
 
Top