I have a Query, and I need to search in 5 fields (USER1 USER2 USER3 USER4 USER5 ) I need to do the search searh with typing in the search name once, and that search string checks all five fields. Also need to have it that if there are five different names in each field, if you do a search for name that is only in one of them, to find that record.
Thanks in advance.
Start Free Trial