Blank Field Problem with a NText (Memo) type of field

[questionnaire database analyst]

Hi all,

I am trying to create a query that eliminates all the records that are empty
in a memo/ntext field. By using the Is Not Null criteria, I am able to
eliminate all the Null records. However, if a user types something into the
field but then deletes the contents, the field is no longer null and I have
no way of eliminating those fields.

I have tried inputting <> "" as the criteria however the program tells me
that "The text, ntext, and image data type cannot be compared or sorted,
except when using is null or like operator. #306"

I really need to eliminate all the empty field so that I can create the
report. Please help. Thanks *1000

 

[John Spencer]

Try using
WHERE [theField] Not Like "" or [TheField] Is Null


"questionnaire database analyst"

 

[questionnaire database analyst]

Thanks, I will try it out!

Try using
WHERE [theField] Not Like "" or [TheField] Is Null


"questionnaire database analyst"

Hi all,

I am trying to create a query that eliminates all the records that are
empty
in a memo/ntext field. By using the Is Not Null criteria, I am able to
eliminate all the Null records. However, if a user types something into
the
field but then deletes the contents, the field is no longer null and I
have
no way of eliminating those fields.

I have tried inputting <> "" as the criteria however the program tells me
that "The text, ntext, and image data type cannot be compared or sorted,
except when using is null or like operator. #306"

I really need to eliminate all the empty field so that I can create the
report. Please help. Thanks *1000