Blank Fields in NOT Null Query Criteria
There are four things that can cause a 'blank' field. Nulls as you already
surmised.
Next come Zero Length Strings. Basically they are just "". That is a text
string with nothing in it. Technically they are different than a null as null
means that you don't know what goes there whereas a ZLS means nothing goest
there.
Then there are non-printable ASCII characters. One would be a paragraph
return or end of line character.
Lastly there are plain old spaces. Something like might look blank, but
isn't.
When confonted with an empty looking field that isn't working as expected, I
check the data with queries looking for things such as Like " *" ; Null; and
"" .
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Steve Stad" wrote:
Why would a few blank fields show up in a query where I am using 'Is Not
Null' in the criteria. The rest of the Nulls are filtered out - but there
are 7 blank fields showing up. I went in to the table and hit delete in each
of the 7 fields but they still show up in the query results.
|