Search Help

[coolkake]

All

I use the following string to search a field
Like "*" & "Example" & "*"
But I don't want to find items with "Example" in them that have "Problem". So I tried the following

Like "*" & "Example" & "*"
Not Like "*" & "Problem" & "*"

My reason for using the above search is I am searching the boby of emails. Any help would be greatly appreciated.

Thanks

Kake

 

[grnzbra]

How about:

Like "*Example*" and Not Like "*Problem*"

 

[coolkake]

That's what I was looking for, works great

Thanks