Show items not null

[mattc66 via AccessMonster.com]

I have created a query.

SELECT qryItemsWith26Chars.ITEM, qryItemsWith26Chars.DESCRIPTION,
qryItemsWith26Chars.[25Char]
FROM qryItemsWith26Chars
WHERE (((qryItemsWith26Chars.[25Char]) Is Not Null));

However when I run the query all items show even the ones that are null or
blank. What can I do to make this work?

Thanks
Matt

 

[KARL DEWEY]

Null is not the same as blank. Null is totally void but blank is a 'zero
lenght string.'
Try this --
WHERE qryItemsWith26Chars.[25Char] Is Not Null AND
qryItemsWith26Chars.[25Char] <>"";

 

[Jerry Whittle]

I've also seen cases where spaces made it seem like the field was null. I do
a select query on the field and see if the criteria below returns any
records. Even if it returns records with something visible in the field, that
could be a problem.

Like " *"
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Null is not the same as blank. Null is totally void but blank is a 'zero
lenght string.'
Try this --
WHERE qryItemsWith26Chars.[25Char] Is Not Null AND
qryItemsWith26Chars.[25Char] <>"";
--
KARL DEWEY
Build a little - Test a little

I have created a query.

SELECT qryItemsWith26Chars.ITEM, qryItemsWith26Chars.DESCRIPTION,
qryItemsWith26Chars.[25Char]
FROM qryItemsWith26Chars
WHERE (((qryItemsWith26Chars.[25Char]) Is Not Null));

However when I run the query all items show even the ones that are null or
blank. What can I do to make this work?

Thanks
Matt

 

[Marshall Barton]

I have created a query.

SELECT qryItemsWith26Chars.ITEM, qryItemsWith26Chars.DESCRIPTION,
qryItemsWith26Chars.[25Char]
FROM qryItemsWith26Chars
WHERE (((qryItemsWith26Chars.[25Char]) Is Not Null));

However when I run the query all items show even the ones that are null or
blank. What can I do to make this work?

Blank is different from Null as is a Zero Length String.
It's unlikely that you actually have a field with just a
space character. OTOH, if the field has it Required and
AllowZeroLength properties set to Yes, then you probably
have ZLS in those records that appear "blank". You can
check for both Null and ZLS by using an expression like:

WHERE 25Char & "" = ""

 

[mattc66 via AccessMonster.com]

Thanks that worked.

Null is not the same as blank. Null is totally void but blank is a 'zero
lenght string.'
Try this --
WHERE qryItemsWith26Chars.[25Char] Is Not Null AND

I have created a query.

[quoted text clipped - 8 lines]

Thanks
Matt