Executive Members within a Grouping

[8track]

Hopefully this is my last big question for a while. This, to me is a bit of a problem.

I need to extract the Members name and their executive position within each of their own group or Chapter. I believe it would be a select statement of some sort.

GroupName = CommitteeMembers.Committee_ID
FirstName LastName = CommitteeMembers.Member_ID
Position = CommitteeMembers.Position

Data should look as follows.

Group Name

President Joe Blow
1st Vice President Sam Blowhard
Secretary John Henry

The second part to this puzzle is which section to put this. Does it go into a second "detail section?

Thanks in advance.

 

[pgtek]

hi
what version of crystal and what database are you using.
And how many position is there in the table.
I might have a suloution for you

cheers

pg

pgtek

 

[8track]

I am using CR v.8 and Access for the database. There would be 5, or maybe 6 positions for each of the groups and the group members show in the detail section of the report with FirstName, LastName, Address, City, PostalCode, EmailAddress, PhoneNO, etc... I think you get the picture.

Some of the same people hold these executive positions and I would like them to display just under the Group Header and before the General Members.

Thank you for your assistance.