You need to look at the formula you use for creating your query expression. I expect you're doing something like:
... + "([Region] = " + fldRegion + ")" + ...
If fldRegion is multi-valued, this results in a mess -- a multi-valued result, when you need a single-valued string as your query. You would have to instead write something like:
... + "([Region] = ("" + @Implode(fldRegion; "" or "") + "")" + ...
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.