If column Words contains *text* then update column Code to "POSTED" otherwise do not update column Code
If column Words contains *text* then update column Code to "POSTED" otherwise do not update column Code
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
This can be calculated when needed, not necessary to actually save into table. But if you really must edit all records:
UPDATE tablename SET Code = "POSTED" WHERE InStr(Words, "something") > 0;
Do you want to match the literal value of "*text*"? Or is this some variable input?
Oh, so this is Excel not Access?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.