How to see blanks in a query?

[Guest]

Hi,

I've got a list I've created and I want to create a query to see certain
records with blanks in them.

I have tried in my criteria to use Blank or Is Blank but it doesn't work. Am
I using the correct criteria.

Thanks very much for your help.

Regards
Janet

 

[Rick B]

Null

is probably what you want.

 

[John Spencer]

Try criteria of
IS Null
to get the records that are "Blank" in the field

Try criteria of
Is Not Null
to get the records that are not "Blank" in the field.

 

[Guest]

In rare cases, it is possible to get a zero length string rather than a Null.
If that is a possiblility, I use this formula to trap for both zero length
strings and Nulls.

Len(Trim(Nz([SomeField],""))) = 0

 

[Guest]

Thanks this is it

Try criteria of
IS Null
to get the records that are "Blank" in the field

Try criteria of
Is Not Null
to get the records that are not "Blank" in the field.

 

[Guest]

Thanks for the help

Null

is probably what you want.

 

[Guest]

Thanks
Janet

In rare cases, it is possible to get a zero length string rather than a Null.
If that is a possiblility, I use this formula to trap for both zero length
strings and Nulls.

Len(Trim(Nz([SomeField],""))) = 0

Try criteria of
IS Null
to get the records that are "Blank" in the field

Try criteria of
Is Not Null
to get the records that are not "Blank" in the field.