Null value question

[Guest]

I have a query that I am trying to pull using "is null" and the query returns
nothing. I know there are several records with a null value in the field I
am specifying it on. Any ideas why it won't return any records?

Thanks.
Lisa

 

[Guest]

The field value might be empty and not Null (usually happen when the value
was deleted or the table was inported from a file)

In that case add a criteria

Is Null Or = ""

To be sure the validation is right use Is Null under the field, then add
another field with Trim(FieldName) to remove spaces and then under the
criteria write = ""

 

[Jason Lepack]

Are they actually null? Or are they just empty strings?

"" does not equal null.

If this doesn't resolve the problem then please post your table
structure, the SQL of the query, and some sample data and we'll take a
deeper look, or if you need more immediate results, email a copy of
the database to my email account.

Cheers,
Jason Lepack