I need a special filter

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

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
 
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
 
Back
Top