The main group in my report is Director & my next group is an eventToDate that I group by month. Under the Director group I have a Code field unique to each Director, but when it prints, it prints a different code, a manager under the Director instead. It’s getting this from the last eventToDate record that is printed.

When my grouping is in the order Code, Director, eventToDate I get the right Code, but the eventToDate group doesn’t include the recordset of the managers linked to the Director. (Each query recordset has a Director attached to it)

The original order I mentioned (Director, eventToDate) has gotten me closest to what I want. But the Code (and a few other fields like GL Code, RegionDesc) reflect the last recordset that is printed under the eventToDate group.

Please advise how I might go about getting a Director’s complete info in the header and have the next group totals include the managers and directors recordset.