how to prev.subtotalat top and Sub total at bottom

[arctushar]

i m having problem as I m new in access. I have some data of 150 rows. Now I want that when I print this. Problem is that every page contain only 40 rows. and it needs 4 pages. So I need to show sub total and prev sub total. eg:

1. First page show 1-40 rows and bottom one cell contain sum of 40 rows data
2. Second page show 41-80 rows with top one cell contain sum of 1-40 rows data and bottom one cell contain sum of 41-80 rows data
3. Similarly Third page show 81-120 rows with top one cell contain sum of 1-80 rows data and bottom one cell contain sum of 81-120 rows data
4. Last page show 121-150 rows with top one cell contain sum of 1-20 rows data and bottom one cell contain Grand Total.

Is it possible. Please help me
if u dont understand me also reply me I will try to make it undersandable

 

[Trevor G]

Microsoft produce sample database's which will give you the example and then you can look behind the reports on how they did to give you the method to apply to yor database.

Please follow the link here and download the report database

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