I have a database called volunteer and a field named "interest" (which volunteers can show what they would be interested in doing) The interest field is set up as a check box field with a value list of: recovery
packs
fundraising
ect ect....
What I want is a report that will show "Recovery" with the list of volunteers that have signed up to do recovery, then list packs and so on and so on.
Recovery
susie smith
tommy jones
Packs
billy thomas
Fundraising
name
name
I tried to set this up using a layout with a leading summary and sorting on interest but the list is showing the interest every time with one person.
Recovery
susie smith
Recovery
Tommy jones
How do I correct this? Thanks!