Use this as criteria --
Like "*"&"marketing"&"*"

"CVoelker" wrote:

> I've imported my Outlook contacts into Access. I want to isolate all records
> where the category field contains the word "marketing". It is sometimes
> first in the field, and sometimes last.