Reports-to show members who belong to different committees

[Guest_imported]

I need to produce a report that shows each member who belongs to various committees, boken down by committees. Right now my fields include Last Name, First Name and each committee which are Yes/No fields. There are people who belong to more than one committee and there name needs to appear under each. How do I set this up!!!!

 

[hennep]

select "Committee 1",[first name] & " " & [last name] from tbl where ysnCommittee1 = True
union
select "Committee 2",[first name] & " " & [last name] from tbl where ysnCommittee2 = True
union
select "Committee 3",[first name] & " " & [last name] from tbl where ysnCommittee3 = True
;

Add a "union select" line for each committee.