Problems summing by page

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

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
 
Roger,

I don't seem to have a group footer on my report. Is
there a way to add one? When i put the information in
the report footer, it did not sum each page. It only
summed my entire report on the last page.

Thanks,

Chuck

-----Original Message-----
You cannot put a aggregate function (ie sum) in a *Page* footer. It must be
either in a Group footer or Report Footer.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe? SUBED1=ACCESS-L

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
Click to expand...


.
Click to expand...
 
In the Sorting and Grouping menu, make sure Group Footer is set to Yes.
This will create a footer for the group.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

ChuckW said:
Roger,

I don't seem to have a group footer on my report. Is
there a way to add one? When i put the information in
the report footer, it did not sum each page. It only
summed my entire report on the last page.

Thanks,

Chuck

-----Original Message-----
You cannot put a aggregate function (ie sum) in a *Page* footer. It must be
either in a Group footer or Report Footer.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe? SUBED1=ACCESS-L

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
Click to expand...


.
Click to expand...
Click to expand...
 
I had the same problem. Read the following article.
Article ID : 296249
Last Review : August 10, 2004
Revision : 4.0

It works Great!! Sums each page.
 
I had the same problem, you need to read this article:
Article ID : 296249
Last Review : August 10, 2004
Revision : 4.0

Sums each page!
 
I had the same problem, you should read this article:
Article ID : 296249
Last Review : August 10, 2004
Revision : 4.0

It sums each page!
 
Back
Top