Query on a text field

[k.roberts]

I have created a query which I want to use to filter out all records
in a table that have an entry in a certain field. The field will
contain text - therefore the criteria needs to instruct the query to
pull through all records that have text in that field - any text. Can
I do this?

 

[Jeff Boyce]

How do you define "text"? The digit 5 is a text character in a postal code,
but might also be considered a numeric value.

Are you looking for a field that is empty vs. filled, or ???

 

[k.roberts]

Yeah, I am looking for a field that is filled otherwise would use the
Null value. Text is just a generic term for the data that is in the
field - the field format is set to Memo.

 

[k.roberts]

Got it - Is Not Null. Thanks!