[AccessD] Referencing Report Footer Calculated Field in Report Header

The reason for putting it at the top as well as the bottom is because the
report may have several pages.  The client wants to see the total on the
front page along with other information for easy transfer to another system.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, 14 February 2013 12:35 p.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Referencing Report Footer Calculated Field in Report
Header

Maybe I'm missing your point, but why would you want to show the grand total
in the report header?  Reports are band-generated, so the data hasn't been
compiled yet at that point unless you create a special function to repeat
all your calculations.  That doesn't make sense to me.

Charlotte

On Wed, Feb 13, 2013 at 2:51 PM, David Emerson <newsgrps at dalyn.co.nz> wrote:

> Team,
>
> I have a batch report which has a subreport of items in the batch and 
> amounts.  On the footer of the main report is a Grand Total of the 
> subreport items as well as a couple of batch amounts.  This works 
> fine.
>
> Here is the control source for the fields:
> = srpOrderDetailPrice!txtTotalCost +
> [txtBaseSetTotal]+[txtFolderLabourTotal]
>
> I would like to show the Grand Total on the report header as well.  
> When I put the formula in the report header section it only includes 
> the first subreport item amount plus the two batch amounts.
>
> It looks like a timing issue.  How can I get the report header field 
> to equal the report footer field amount?
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand