MS Access Report Question

In the attached database I am trying to do a Report (Rep1 ) for the sum of Total Income, Total backup withholding.
When  I use Sum, then the total of the field from the table is calculated and displayed.
If you see the report ( using print preview option), it will fetch atleast 3 records on the page.
I would like to have the total of those 3 or 4records only (per page )and not of the whole table.
Is there any way  to do it ?
I am using MS Access 2002
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris BRetiredCommented:
I have done income for you (roughly) - add a running total in detail (you can hide it) then use that control in page footer.

Chris B

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chitralekhaaAuthor Commented:
Hi Chris,
Thanks, but when I run the report I also see another total box on new page. Can that be eliminated.

The reason I am saying this because. I am going to use the same method to do sum another field. If you notice, there are 3 fields  I mentioned in the footer
1) Total Income, 2 )Total Tax Witholding excluding Backup Withholding and 3 )Total Backup Withholding

I have yet to add field 2 to the table. Currently working on only 2 fields.
Please help.
chitralekhaaAuthor Commented:
Initially it took me some time to adjust the report. But your method worked for me. Thanks.
Chris BRetiredCommented:
Hi. Sorry, I went to bed. As you no doubt figured, I put the control to the side, but in reality you would drop it into the middle of the existing detail section then hide it so it didn't affect the layout.

Good luck

Chris B
chitralekhaaAuthor Commented:
The question is already answered, but I would like to know if there is a way to add the total only for the page of the report printed
What I mean is the total is accumulated page by page . That is fine, but can we also show total for individual page.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.