Balance brought forward in a report

[eneyardi]

The attached file is my sample program for inventory report, I want the (Balance brought forward) to start in second page (It must not appear in first page). And how to put the total value of first page in (Balance brought forward)

heres i want to achieved in (Balance brought forward)

1st page - Balance carried forward = 68,644.40

2nd page - Balance brought forward = 68,644.40
Balance carried forward = 110,739.56

3rd page - Balance brought forward = 110,739.56
- Balance carried forward = 1,719,767.65

and so on..

[Rabbit]

The only way I can think of to do this is to figure out how many records fit on a page and then use that to group and summarize the records

[dsatino]

It's a bit of a pain, but it can be done. See this

http://office.microsoft.com/en-us/access-help/summing-in-reports-HA001122444.aspx

[eneyardi]

Thanks for your reply guys, based on your given link, its only explaining the grouping and summarizing of records, it can be done using some trick but it's a bit complicated and for every records update, I must change the number of records, that's not a good idea i think. Maybe i will not include Balance brought forward to report anymore.