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"...
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...