show total in each page , How
in [Reports]
|
From: shwan on 17 Apr 2010 15:40 I have a report which is contains : ID , Name , Salary ..... etc , 1.................. 2................ 3.............. page 1 total [salary] = ??? -------------------------------------------------------- ID , Name , Salary ..... etc , 1.................. 2................ 3.............. page 2 total [salary] = ??? please tell me How ???
From: Marshall Barton on 17 Apr 2010 17:24 shwan wrote: >I have a report which is contains : >ID , Name , Salary ..... etc , >1.................. >2................ >3.............. > > >page 1 total [salary] = ??? >-------------------------------------------------------- >ID , Name , Salary ..... etc , >1.................. >2................ >3.............. > > >page 2 total [salary] = ??? > That's a rather vague example of what you are doing. If the total is just from a page's worth of detail records, then try this: Add an (invisible?) text box (named txtRunTotal) to the detail section. Set the text box's control source to the Salary field and set its RunningSum property to Over All. Add a text box (named txtPageRunTotal) to the page footer section. Leave the control source empty. Add another text box (named txtPageTotal) to the page footer section to display the total on the page. Leave the control source empty. Then add a line of code to the report header section's Print event to initialize the txtPageTotal text box: Me.txtPageTotal = 0 Finally, add code to the Page Footer section's Print event procedure: Me.txtPageTotal = Me.txtRunTotal - Me.txtPageRunTotal Me.txtPageRunTotal = Me.txtRunAmount -- Marsh MVP [MS Access]
|
Pages: 1 Prev: Trouble with my sorting and grouping Next: Pie Chart Formating |