I am using a multivalued field in my database and am having some issues determining if a specific value is included as a selection. I was going to use an iif statement that said iif([projects.regions] = "Asia", do something, do something else). This did not work properly. If only “Asia” was selected, this evaluated to true and it worked fine. But if there was more than one value selected in the multivalued field (“US” and “Asia”) this did not evaluate to true in the IIF statement. This is all in one table and the multiple values show up as comma dilemitted selections in the fields. I feel like the IIf statement is trying to compare the string "US" to the string "US", "EMEA", "LATAM" and evaluating false. I have tried IN and LIKE options instead of "=" in the formula and it still isn't working. My gut tells me there is an easy fix, I have spent many hours trying to figure this out. Any advice would be appreciated. Thanks in advance.