Sorted Group Duplicate Header Label Problems

[Stan_B]

I have a report where I wish to group the "Current" employees from the
"Inactive" (Former) employees. I can get the report to perform this group
action, but when I wish to place a header Label above this group (Current)
section, the same header label that I place in the other (Inactive) section
appears in this section and vice-versa, -- I wind up with the labels
"Current" and "Inactive" in BOTH sections. What I want is the "Current"
label above the current employees and the "Inactive" label above the former
employees. I am using the two expressions "=([EmpStatus]="C")" {for the
current employees} -and- "=([EmpStatus]<>"C") {for the 'inactive' employees}
to sort/group in the group properties box of the sort/group window. Any and
all suggestions will be appreciated! Thank You!

 

[Duane Hookom]

I'm not sure where you have what expression. Your sorting and grouping dialog
should only need the field name:
[EmpStatus]
You can display the group header section and add a text box to this header
with a control source like:
=IIf(EmpStatus="c","Current","Inactive")