Extracting from a MEMO field

[bthill]

I have a MEMO field and I want to be able to search it to see if another field within the same table exists within the MEMO field.

 

[David R]

Ummmm...huh?

another field within the same table exists within the MEMO field

Translate or give a concrete example please? Are you storing field names in your memo field or something?

 

[bthill]

I actually used the following where statement in my query and it worked:

like "*" & [fieldname] & "*"

Thanks!