I have a table woth values that I am strying to search on. I have anotehr tabel of possibel search values.
I have the possible search values in a list box. When I select a single item in the list box it returns a result, but when I have multiple items seelcted nothing is returned.
SubStringCount
([Ifpay Paymn Detail],[SearchFields])
Any ideas how to use this for multiple selections?