Is Null

[1943]

In my qry, Is Null does not list fields that have a "0" value. It only shows the fields that are blank. I need it to include both situations. I have used <1 or Is Null and when I use "<" it list nothing. The fields are numeric and I have change them to text and same results.


Can anyone help?

DWH Access 2003

[NoellaG]

Hi,

instead of testing the numeric value itself, test the calculated value NZ([MyField],0) on being zero. The NZ function replaces a Null value with the value given in the second parameter.

greetings
NG

[1943]

I tried that and it does not work either.

Thanks,

DWH

[orange]

Here is a fantastic reference on NULL.
http://allenbrowne.com/casu-12.html

Enjoy!