I have a recurring problem: Say I have a set of data like so:
Record 1
- Table A - Event 1 - attended
                 Event 2 - not attended
                 Event 3 - attended
Record 2
- Table A - Event 1 - not attended
                 Event 2 - not attended
                 Event 3 - attended
etc....

Of my data set, I want to select only those people who attended event 1.  However, I want to show ALL data for Events 1-3.  When I do a record selection or a group selection for condition (Event ID = 1 and Event 1 = Attended), I only ever see Event 1 information.

Thus, the data looks like so, in "Details:"

Record 1      Event 1     Attended

I want it to look like this:

Record 1      Event 1     Attended
Record 1      Event 2     Not Attended
Record 1      Event 3     Attended

I know this is because it is selecting only Event 1.  But I want that as an inclusive condition, to include ALL the records for "Record 1", not only Event 1 info.

The only way I know how to show the information I want is through subreports, linking the records, and making a whole new report for Events 1-3 that matches my record selection in the main report.  Can anyone tell me if this problem can be solved?

Thank you!