SELECT Query on blank record field

[Mike]

Hi:

I have a table with a couple of text fields, and I'm trying to do a query to
find blank ("") fields.

On one of the fields, I can do the query, and it turns up the blank records.
On the other field, the query does not seem to work, despite the fact that
both fields are configured the same (with the exception of text length).
The query result shows up just one record, but all the display fields are
blank (I had created six test records that should have been returned by the
query).

This is not much to go on, but is there something obvious I'm missing?

Thanks in advance if you can help.

Mike

 

[Noozer]

Remember that a NULL field is NOT the same as a "" field

Might try using ISNULL() or adding "" to the field (ie WHERE ""+Field = "")

 

[Mike]

Oh Yeah, the NULL stuff!! When I first run an update query to eliminate
nulls in the field, and then re-try the select query, it works, of course!

Thanks for a quick and useful response, and for contributing your expertise.