I have a database that has 16 fields that can be either "effective" or Opportunity".
If the field is marked "Opportunity", the user has to comment about that specific field in a comment section.
The comment section has a drop down box that allows the user to choose which of the 16 fields they are commenting on.
The user has three separate comment fields in which he/she can discuss the reason they feel there is an "Opportunity".
Works great - now I'm working on the report, and I need to group all like fields which have been commented on from the three comment fields.
I can get it to group all of comment 1's "like" fields, i.e.
1.1 Is Fair and Consistent
then it lists the comment, behavior, impact, etc. (which accompany that comment section.
My problem: I want Comment 1, Comment 2, and Comment 3 to list all of the 1.1's at one time. etc. regardless of whether or not the comment was listed in Comment 1, 2, or 3. Instead it's giving me all of Comment 1's 1.1s, and then Comment 1's 1.2, 1.3, etc., then Comment 2's 1.1s, then 1.2, 1.3, etc. and then Comment 3's 1.1, 1.2, 1.3, etc.