I have built a report which includes a subreport. At the top of each
page I have a company name and a total of all sales receipts. The
subreport contains a list of each sales receipt. Each company is on a
separate page. My problem is in calculating the total of the sales
receipts which shows at the top of the page. How do I ask Access to
look at only the company receipts shown in the subreport on the page
and use that to create a Sum to be displayed at the top of the page?

I am able to do this in the footer by using =Sum([SalesReceipt]), but
I can't seem to do this outside of the footer. When I put the same
statement at the top of the page it displays the total of all sales
receipts for all companies on all pages.

Thanks for any help you can offer.

russ_sd (AT) yahoo (DOT) com (Russ) wrote in message news:<bc6f7280.0405110544.b36ae75 (AT) posting (DOT) google.com>...
If you would be willing to look at a Java product our Super*SQL can
produce plain text or web formatted reports directly from Access.
Super*SQL has a lot of formatting options and uses SQL queries so that
a wide variety of reports can be generated. If you are interested,
visit www.sqlmagic.com