Does field contain string from another field in a seperate table

[swaink]

Morning all please bear with me please as Access is not my strong point but I'm working on it

I need to update a field in one table to show a null value if it contains certain strings

For example if the field contains "Company" or "International" of "Construction" etc I will make those fields blank

To speed the process I have created a separate table called [CleanUp] and in this table I have listed all of the variables I want to search for include those mentioned. In my query I have shown just two fields "Organisation", "Contact" both from the Master Table, at the minute Contact is a straight copy of Organisation. The aim is to blank out any of the fields in the "Contact" column where they contain my list of names in the [ContClean] table

Currently I have tried to use Where "Contact" in table one is like the "LikeNames" in my second table
I.E Like ('*'+[ContClean].[LikeName]+'*') but this is not returning field with those names listed I seem to get everything regardless

All help is appreciated and this ine has me stumped for the minute

Thank you

Kevin

 

[swaink]

Ok solved the issue of referring to my but am finding that it does rum rather slow

My list in the [ContClean] table contains circa 100 rows so am guessing there is an issue with constantly referring to the table

 

[TerryHogarth21]

Try this in your WHERE clause

 UPDATE Table1 SET Table1.NameField = Null
WHERE NameField LIKE "Company*" OR NameField LIKE "International" OR NameField LIKE "Construction";