How to have page sum before and after detail section? 1

[Fekri]

Hi,

I need to have sum in three column in my report in end of each page and show that sum value in first of next page as first row before detail section.

Of course in page 1 I should not have any sum before detail because no any sum value in previous page,
And In end of report also I don't need this sumurise.

Thanks for any help and idea...

Ali

 

[GingerR]

You can't sum a PAGE of data. Only an entire report, or groupings.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[THWatson]

Well, actually, even though it's not the usual thing...it is possible to get totals for a page.

Here's a link on the Microsoft site...

http://office.microsoft.com/en-us/access/HA011224441033.aspx

Tom