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.

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?

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

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

Thanks!