Problems - Query does not filter blank fields with IS NULL

  • Thread starter Thread starter Maik
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert zero-length string or blank cell to null 3
blank values not null 5
Is Null 2
Filter By Selection error for blank fields 2
Blank Fields in NOT Null Query Criteria 5
Parameter Query With Null Values 3
NOT function not working - can prove with screenshots 1
#error - Blank 3

Back
Top