I'm using MS Access 2003. I have a query which contains a field that has a string of words.
My problem is I want search for rows which contain words Biro and Blue. I'm using the formula - Like "Biro" And "Blue" - but there are no results. But there are rows which contain both of the words. What is the problem?
Instead of the word and, use the word OR. Or instead of putting criteria on one row, put biro on one criteria row, blue on the other but match up any other criteria to the two rows.