"Is Null" not finding null values-?? 3

[dpav29]

OK, I know it sounds simple, and I hope it is. A text field with many records having null values. My very simple query isn't picking them up with "is null". It's a text field, not required, zero length allowed (though these aren't zero length strings).

The only thing unusual is that I imported the table from and excel worksheet. In excel the field was general. Anyone know what's going on here?

 

[Isadore]

Try using "IsNull"

 

[dpav29]

That didn't do it. Any other ideas?

 

[riny]

Do some testing.
Replace your IsNull([Field]) query temporarily with:
Msgbox [Field]
to see what it says, then maybe you'll understand what's up

hth

 

[dpav29]

Can you explain that. . .not sure how to go about it. Thanks!

 

[JimHorton]

dpav,
Are you *sure* the field is Null and not a zero length string? Ie, if you put "" in the criteria will they show? Also, check for other 'hidden' criteria--such as those D'OH! criteria that we've all forgotten about--you know...way over at the far right column, off the edge of the screen? Those have gotten me more than once...
--Jim

 

[Jayz]

Check to see in the textbox properties that a default value of some sort is present. if so, clear.

You may also want to check out this article:

http://www.evolt.org/article/empty_nothing_and_null_how_do_you_feel_today/17/346/

 

[dpav29]

Thanks a lot everyone! They WERE zero length afterall (D'OH!!!). I need a drink.

 

[tlbroadbent]

You can check for both null and zero length strings if you use the IsNull funcion.

Where IsNull(ColName, "&quot = "" Terry L. Broadbent - DBA

http://tlbroadbent.home.attbi.com/index.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers."

 

[JimHorton]

Terry,
I think you mean the NZ() Function...
--Jim

 

[tlbroadbent]

Thanks for the correction, Jim. I'm having difficulty keeping T-SQL and Jet straight this week. This is about the 4th or 5th time I've posted a T-SQL answer in an Access forum. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.