Normally, I'd set a "Contains" filter on my str开发者_运维问答ing field, and enter my value in the modal box, but I want to audit the process.
UPDATE Data SET Data.[Assumed Expires]=Data.[Assumed Expires]+365 WHERE Data.[Description]=strSearch;
Thanks a pile!
I can't remember Access syntax exactly, but something like this to do a substring match:
WHERE Data.[Description] like '*' & strSearch & '*';
精彩评论