Help with Report!!!

[Snap]

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!

[LaRetta]

We need to know whether your Volunteers are a separate table. If so, create the report in the Volunteers table. You want the report to reside in the table where each record is a volunteer. Then your report can be created thus:

* New Layout

* Select columnar [next]

* Report with grouped data [next]

* Select your Interest field and the volunteer's name field [next]

* Organize by Interest [next]

* Select your theme and header/footer information [next]

* Let FM create a script for you - it must be sorted by Interest.

The Interest field should be standard edit field and NOT a checkbox or popup.

Edited December 21, 2007 by Guest

[LaRetta]

Correction ... not where each record is a Volunteer - not like a Staff table - but rather a table of the volunteer activites.

[comment]

IIUC, this is a many-to-many - each volunteer can sign up for multiple interests (hence the checkbox).

However, the required report cannot be produced until the checkbox is replaced with a join table.