How to see blanks in a query?

G

Grd

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
 
J

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.
 
K

Klatuu

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
 
G

Grd

Thanks this is it

John Spencer said:
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.
Click to expand...
 
G

Grd

Thanks
Janet

Klatuu said:
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

John Spencer said:
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.
Click to expand...
Click to expand...
 
Top