Grouping

S

srctr

I am trying to use the grouping feature. My problem is the header for the
two groups shows as a box in both areas, words are only showing in the
correct area. How do I get the one group header to show only for that group?
Looks like this:

blank box
Board of Directors

BDName1
BDName2
BDetc

Participant's Council
blank box
PCName1
PCName2
PCetc.

I am sorting and grouping on
Particpant's Council field - Ascending, Group Header = Yes, Group Footer =
No, Group on = Each Value, Group Interval = 1, Keep Together = No
Board of Directors Field - Ascending, Group Header = Yes, Group Footer = No,
Group on = Each Value, Group Interval = 1, Keep Together = No
Last Name field - Ascending, Group Header = No, Group Footer = No, Group on
= Each Value, Group Interval = 1, Keep Together = No
First Name field - Ascending, Group Header = No, Group Footer = No, Group on
= Each Value, Group Interval = 1, Keep Together = No

I have tried everything, changes settings for everything. I can not figure
out why the group header shows in both areas and not just it's own area.

Thanks
 
D

Duane Hookom

I expect [Participant Council] and [Board of Directors] are yes/no fields. I
don't care much for this structure but you could try an expression in a text
box like:

=IIf([Participant Council],"Participant's Council",IIf([Board of
Directors],"Board of Directors","Just an Ordinary Member"))
 
S

srctr

Thank you that worked. I had both items selected in the sorting and grouping
with headers yes for both. I removed the one and put the text box in as you
stated and now my report looks professional.

Thanks

Duane Hookom said:
I expect [Participant Council] and [Board of Directors] are yes/no fields. I
don't care much for this structure but you could try an expression in a text
box like:

=IIf([Participant Council],"Participant's Council",IIf([Board of
Directors],"Board of Directors","Just an Ordinary Member"))

--
Duane Hookom
Microsoft Access MVP


srctr said:
I am trying to use the grouping feature. My problem is the header for the
two groups shows as a box in both areas, words are only showing in the
correct area. How do I get the one group header to show only for that group?
Looks like this:

blank box
Board of Directors

BDName1
BDName2
BDetc

Participant's Council
blank box
PCName1
PCName2
PCetc.

I am sorting and grouping on
Particpant's Council field - Ascending, Group Header = Yes, Group Footer =
No, Group on = Each Value, Group Interval = 1, Keep Together = No
Board of Directors Field - Ascending, Group Header = Yes, Group Footer = No,
Group on = Each Value, Group Interval = 1, Keep Together = No
Last Name field - Ascending, Group Header = No, Group Footer = No, Group on
= Each Value, Group Interval = 1, Keep Together = No
First Name field - Ascending, Group Header = No, Group Footer = No, Group on
= Each Value, Group Interval = 1, Keep Together = No

I have tried everything, changes settings for everything. I can not figure
out why the group header shows in both areas and not just it's own area.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top