I need a special filter

[Jimmy]

In my table I have a field called C1. The data in that field may contain
words with the symbol "&" between them. I want to find the records that
contain the symbol "&" but it doesn't seem to work. What I am trying is
filtering with:
Like "*&*"
I get no results eventhough there are alot of records with that symbol.
Can someone tell me what I am doing wrong and what must I do.
Thanks Jimmy

 

[Ed Robichaud]

You've got the criteria correct! Try creating a test table and/or adding a
few dummy records with that symbol, then filtering for them.
-Ed