A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sum of every page in a report



 
 
Thread Tools Display Modes
  #1  
Old November 13th, 2009, 09:11 PM posted to microsoft.public.access.tablesdbdesign
Reva
external usenet poster
 
Posts: 15
Default Sum of every page in a report

I have a multi page report which includes a field to calculate the
[Qty]*[Rate]. I would like to have a sum shown at the bottom of each page
and a grand total at the end of the report. Can anyone suggest how to sum
the [ExtendedCost] at the end of each page?
  #2  
Old November 14th, 2009, 02:01 AM posted to microsoft.public.access.tablesdbdesign
Barry A&P[_2_]
external usenet poster
 
Posts: 119
Default Sum of every page in a report

Reva
depending on grouping and report setup and im sure lots of other stuff Try a
control on your reports page footer for =sum([name of your details control
with qty*Rate]) and same thing in the reports footer. but i am not exactly
sure about your page breaks ext..

or create a new report with the report wizard and check out the "Summary
Options" button when it asks you about sorting and see how the wizard does it

"Reva" wrote:

I have a multi page report which includes a field to calculate the
[Qty]*[Rate]. I would like to have a sum shown at the bottom of each page
and a grand total at the end of the report. Can anyone suggest how to sum
the [ExtendedCost] at the end of each page?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.