Unanswered: I am new to MS Access and need to find random words in a string
The example below is in Access 2000
I have a table that consists of three fields...
Field 1 is "MATCHED" and has nothingin it... it is null
Field 2 is "SUBMODEL" and contains various text or may be null
Field 3 is "NOTE" and contains a text string with various text separated by commas and or semi colons.
I need to compare "SUBMODEL" to "NOTE" and update "MATCHED" to "MATCHED" when SUBMODEL is found in NOTE. Need to be careful because both CX and CXL are or could be in the note field as well as other similar submodels.
|GL|EXCEPT GS, CXL, GL, BASE MODEL;
|BASE MODEL|EXCEPT GS, CXL, GL, BASE MODEL;
|CX|EXCEPT GS, CXL, GL, BASE MODEL;
|CXL|EXCEPT GS, CXL, GL, BASE MODEL;
|GS|EXCEPT GS, CXL, GL, BASE MODEL;