MCTampa
Board Regular
- Joined
- Apr 14, 2016
- Messages
- 97
Resort Codes | Resort Searches |
MM1 | HNS;HSL;MG1;MG3;MG5;MGA;MM1;WNL |
GTR | HNS;GTR;MG1;MG3;MG5;MGA;MML;WNL |
NCV | HNS;HSL;MG1;MG3;MG5;MGA;MML;WNL |
MKO | HNS;HSL;MG1;MG3;MG5;MGA;MKO;WNL |
<tbody>
</tbody>
I have a table with two columns: list of resort codes and a list of resort searches.
I would like to create query in which Access evaluates whether or not a resort code is found in the corresponding search list.
I am trying to use the Like method, but it only seems to work when there is just one resort in the search field and it happen to be a match.
Any ideas?
Thanks
Last edited: