Hi,

I have a query called projects that has five fields:  
company name, project name, employees, hours and cost.
One company may have three or four projects.  created a
form with a combo box of companies where a user can
select a company and get all of the projects for that
company in the form of a report.  I then grouped the
report by project name and have then have the report
force a new page before the project name header section.  
This allows each project with the details of who is
working on it appear on different pages.  The problem is
that I want to now sum by page or by project.

I placed a text box with =sum([cost]) in the report
footer but this sums all projects on the final page
rather than on each page.  When I placed the =sum([cost])
in the page footer I get an #error at the bottom of each
page.  

Can anyone help me to sum by page (i.e. by project) with
the sum values appearing on the bottom of each page?

Thanks,

Chuck