Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / August 2007

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
HeatherD25 - 31 Aug 2007 19:38 GMT
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 - 31 Aug 2007 20:30 GMT
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".
Signature

Duane Hookom
Microsoft Access MVP

> Hi,
>
[quoted text clipped - 7 lines]
> Thanks!!
> Heather
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.