Unanswered: Multi Criteria search in the same field ?
Is it possible to search for at least 2 criteria within the same field? Please see attachment. Currently I search for the first 11 characters of a class call Intensive Reading, but I also want to include the Reading class without Intensive. How can I proceed ?
You can combine several conditions for the same Field with the OR operator. Also refrain from using VBA functions in a query when they are not absolutely necessary. This:
WHERE Left([ClassName], 11) = 'Intensive R'
Can probably be replaced by:
WHERE [ClassName] Like 'Intensive R*'
The exception being that you cannot use this technique if you have other possible data for the column beginning with "Intensive R" then something different from "eading" ("Intensive Rafting", "Intensive Ruling", etc.) that you do not want in the selection (and that your expression would return anyway).
Combining both conditions, we have:
WHERE [ClassName] Like 'Intensive R*' OR [ClassName] Like 'Reading*'