Sorting by custom values, checkboxes

[sepurina]

I have a field that uses checkboxes with custom values.

I want to sort by these custom values. (I have club members select 2 forms of community service -- I want to then list everyone who signed on for each of the 5 forms. The problem is, the standard sort by custom value will only allow the club member's name to appear in the first of the custom values checked off. Their name will not appear under second option they have checked. I want the names to appear twice in the sort, but the sort will not repeat. How do I generate a list of names by these checkbox custom values?

[Vaughan]

That's because the checkbox inserts each selected value into the one field, paragraph delimited.

What you really want is to indicate that a person has selected two forms of service and to be able to list them: for this a portal with related records would be better.

Listing the names would then be a snap, and each person would be lists as many times as they have volunteered.