Update Query

[dsegu]

Hello,

I am looking to create an update query that searches for key words in a comment cell using "is like" and updates the content of the cell with just that keyword.

Any thoughts on how to create this query? I open to suggestions if there are better ways to do this.



Thank you.

[orange]

Please show an example of
a) what would search for, and
b) what you would update the cell to.

Cell is a spreadsheet term, not used in Access/database.

[dsegu]

Please show an example of
a) what would search for, and
b) what you would update the cell to.

Cell is a spreadsheet term, not used in Access/database.

Hello,

Some examples of what is currently in the field: 1) Customer stated she was not sure how to add her offer ($.20 Gas Reward with purchase of $20 or more).


2)

The store called about a free offer not working at the store.

In these two cases, I would like to search for the word "gas" and "fuel" and "free"

The comment field for example number one would be updated to read "gas", the comment field in for example number two would be updated to read "free"


There will be more key words which I have not decided on yet. I am looking for a trend in the comments.

Thank you!

[orange]

You could try something like the following in the sql view of query wizard.
You'd have to change the table and field name accordingly to match your database.

Select * from YourTable
Where 
Commentfield like "* gas *"  Or
Commentfield like "* free *"  Or
Commentfield like "* fuel *"