Query on a text field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

k.roberts@ucas.ac.uk - 13 Jan 2006 13:21 GMT

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?

Reply to this Message

Jeff Boyce - 13 Jan 2006 13:33 GMT

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 ???

Signature

More info, please ...

Jeff Boyce
<Office/Access MVP>

> 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?

Reply to this Message

k.roberts@ucas.ac.uk - 13 Jan 2006 13:40 GMT

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.

Reply to this Message

k.roberts@ucas.ac.uk - 13 Jan 2006 14:45 GMT

Got it - Is Not Null. Thanks!

Reply to this Message