I have a problem with running sum on page header (access 2003).
I want to have running sum on page footer and page header. in page footer is all ok, but running sum on the next page header is wrong (higher increased by the first record in next page.
e.g
first page header------running sum=2 (false)
detail
2
3
5
6
first page footer------running sum=16 (true)
second page header------running sum=17 (false)
detail
1
2
6
second page footer------running sum=25 (true)
How do I solve this problem?