My search doesn't bring back all the results I was hoping to get
Hi, I was wondering if someone can help. I have created a search feature and I want to be able to search 4 db fields for one or more words. When I do that, it doesn't seem to search all the fields I listed because it brings back less results.
I'm attaching a screenshot of the dialogue box if that helps.
Basically what I would like:
If a user searches Adult Volunteer the search for this term should look in 4 of my fields for "Adult Volunteer" regardless of where the string is within the fields, but it should be an exact match.
Also, please let me know if this is something I can do within the data assist dialogue box.
I really appreciate your help. Thank you