swaink
Active Member
- Joined
- Feb 15, 2002
- Messages
- 432
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
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