From: shwan on
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
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]