Group by three checkboxes

[lizzywu]

I have three checkboxes as check1, check2, check3. There can be 7 types of their combination (check1, check2, check3, check1&2, check2&3, check1&3, check 1, 2&3). And I want to group data by these seven combos in one report.



Is there any way to do that?

Thank you.

[June7]

You would have to assign a value to each record dependent on what boxes are checked and then group by that value. In a query, or in Calculated field of table, have nested IIF expression. Seven is supposed to be the limit for nested IIF, so you just might be able to do it.

IIF(combo1=Yes and combo2=Yes And combo3=Yes,7,IIF(combo2=Yes And combo3=Yes,6,IIF(combo1=Yes And combo3=Yes,5,IIF(combo1=Yes And combo2=Yes,4,IIF(combo3=Yes,3,IIF(combo2=Yes,2,IIF (combo1=Yes,1,"")

or try Switch function
Switch(combo1=Yes And combo2=Yes And combo3=Yes,7, combo2=Yes And combo3=Yes,6, combo1=Yes And combo3=Yes,5, combo1=Yes And combo2=Yes,4, combo3=Yes,3, combo2=Yes,2, combo1=Yes,1)

[lizzywu]

Thank you so much, June.
Both IIF and Switch functions work well in my query. Problem solved!