Darryl Collins
darryl at whittleconsulting.com.au
Wed Feb 13 17:50:17 CST 2013
Totally makes sense. "To Add Up" The Romans had it right - they also used to put the totals up the top. We still use the term but the current fashion is totals at the bottom (or "To Add Down") - dumb idea IMHO. I always put totals in the header (up the top), along with out meta data (Min, Max, Count, Means etc). Maybe it is an Excel thing. There are HUGE advantages to doing this. They include, but not limited to 1: The totals / counts / etc are always visible and easily seen. If they are down the bottom and you you need to keep finding the bottom to find the result - and the bottom will keep moving. 2: Doesn't matter how many additional rows of data you add. 3: The totals are always located and found in the same place, this has big advantages for machines and humans. Totally get Totals in the headers - sadly Access is not good at this. This is one area Excel excels ;) Cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Thursday, 14 February 2013 10:35 AM 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 > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com