Group Headers

[srctr]

I have a report that I want to split. One part shows who is a Board of
Director and the other part shows who is on the Participant's Council. when
I use the sorting and grouping feature it splits it nicely. I just can't get
it to label each part correctly. How do I get it to label the Board of
Director group as Board of Directors and the Participant's Council as
Participant's Council?

Thanks

 

[Duane Hookom]

Your record source of the report should include the field that actually
stores the titles. I expect you are using a lookup field in your table design
which is a confusing mis-feature.

 

[Marshall Barton]

I have a report that I want to split. One part shows who is a Board of
Director and the other part shows who is on the Participant's Council. when
I use the sorting and grouping feature it splits it nicely. I just can't get
it to label each part correctly. How do I get it to label the Board of
Director group as Board of Directors and the Participant's Council as
Participant's Council?

How do you distinguish between them for grouping?

I'll guess that you have a field in the table (check box?)
that you are grouping by. If so, you could use a group
header text box expression to calculate the "label":

=IIf([board member field] = True, "Board of Directors",
"Participant's Council")