How can I put the value from a footer in the report header?

[HeatherD25]

Hi,

I have a report with a group on "team name" and "person". I have a header
and footer set up for each, so I get a total of hours worked for each person,
and a total of hours worked for each team.
I would like to create a "cover sheet summary" in the report header section
that lists each team and the total hours worked (along with some other things
I've calculated in the "team name" footer). How do I reference these?

Thanks!!
Heather

 

[Duane Hookom]

I wouldn't bother trying to reference existing controls in other sections.
Use a subreport based on a totals query that calculates exactly what you want
to see in the "cover sheet summary".