Re: How to update a column in table by matching partial keywords in another table
I think what is wanted is the keyword from a longer word
colname "keyfield" as run for "abcruntoday" and walk for walkman.
and that what is proposed will update the target field to the entire contents of the other field; e.g. field will get updated to abcruntoday, not run?
Then again, maybe I've interpreted the sql statement incorrectly. I'll bow out and study it a bit more.
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Last edited by Micron; 11-10-2019 at 08:00 AM.
Reason: added comment