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

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.

-- 
Duane Hookom
Microsoft Access MVP


"srctr" wrote:

> 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

srctr wrote:

>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")

-- 
Marsh
MVP [MS Access]