I have a Combo Box / Value List accepting Multiple Values
e.g. I am using "skin colour"
The values are "pale", "midrange" and "dark"
If someone has chosed a combination including "pale" from the list, how do I pick this up in a query / Build query process?
e.g. If it was a single-vale field like glassesYN it would be easy:
IIF([glassesYN]=True, "They are wearing glasses", "They are not")
But how do I do this with a combo box of multiple values?
IIF("pale" In ([skincolourcombo]), "They include pale skin", "They do not")
...this looks good to me but does not work because access needs a literal set of values in the In() part.
How can I do this?
P.S. I would prefer answers stick to basic query filtering as I'm not proficient with using the VB editor.