Matching Part Of A word in series of words

[chriswilliam]

Fantastic site!

This is the first time i've posted - Everything I normally have a Question around is answered already!

Can anyone help with the following.

I have a table with 3 columns

Reference | Supplier Notes | Found |
ABC12312 | Text Text ABC12312 text text | <Yes>|

I want to perform the following test. If Reference is found in the supplier notes match bring back a result of yes If not then leave the detail blank.

It seems simple enough but i can get my head around this

Can anyone help?

 

[Rickster57]

words

Use the Instr function. If the returned value is greater than zero then set the found field to "Yes".

 

[chriswilliam]

Massive thanks for the reply although I now realise I've asked the wrong type of question.


I unfortunately have to perform the following on Old data - and there is no way of getting around it.

Look for "Reference" in another table so i can use the Instr function to update a column with "Yes". I now realise I also need to bring back the Company Name and the "Status"

I have attached an example based on a scenario and the desired result. If i try and pull through the data with an Update Query it asks me for the parameters which I am unable to enter for every single row.

Can anyone help on this ? is this a simple Update Query now or should i be posting this question elsewhere?

To try and Explain what I want to do.

Match The reference number in a string of text - Update a field to say it's matched - then update The status and the name from where it was matched from.

Massive thanks in advance for any replies!

Apologies for not making this clear when i first asked the question!