1 of 1 people found this helpful
This issue lies with the fact that A checkbox group enters text into it's field in such a way that each selected checkbox value is entered into the field in the order the boxes were clicked, separated by returns.
Thus one such record might list:
in that field. Another might list:
and a third might just have:
You'd need to separate the different values into different records in a related table before you can get the report that you want to see here.
Define a table, RolesConsidered, with these fields:
PlayID, RoleName, PlayerID
Add a relationship:
Players::PlayerID = RolesConsidered::PlayerID (enable "allow creation of ..." for RolesConsidered in this relationship)
Now you can add a portal to RolesConsidered on the Players layout and you can select roles in as many rows of the portal as you need. Use the PlayID field to identify the relevant play (or musical or dance or movie or...)
You can then base your report on the RolesConsidered table, but add fields as needed from the Players table and any related "Plays" table to fill in additional info as needed for your report.