Simple Column Total on Report

  • Thread starter Thread starter Frank Wagner
  • Start date Start date
F

Frank Wagner

I am creating a report based on a summation query that is
a count of the number of records (CountOfID) by
approximately 10 values of data in one field.

The query does not have a total value, just a count for
each particular value. When I create a report with the
report wizard, it does not have a total, and except for a
total in the page footer at the bottom of the page, there
is no place to put one. If I add a group for each value,
I get 10 places for the totals. Is there any way to
place a total right at the end of the detail that is a
sum of the 10 values in the column.

Also when create a text box in the page footer, and put
in the formula =Sum([CountOfID]) I get an error for that
box on the report.

Any help would be appreciated.

Thanks

Frank Wagner
 
View the Report Header and Footer. Then place your sum text box in the
Report Footer section.
 
Thanks Duane, it works like a charm.

Frank Wagner
-----Original Message-----
View the Report Header and Footer. Then place your sum text box in the
Report Footer section.

--
Duane Hookom
MS Access MVP


Frank Wagner said:
I am creating a report based on a summation query that is
a count of the number of records (CountOfID) by
approximately 10 values of data in one field.

The query does not have a total value, just a count for
each particular value. When I create a report with the
report wizard, it does not have a total, and except for a
total in the page footer at the bottom of the page, there
is no place to put one. If I add a group for each value,
I get 10 places for the totals. Is there any way to
place a total right at the end of the detail that is a
sum of the 10 values in the column.

Also when create a text box in the page footer, and put
in the formula =Sum([CountOfID]) I get an error for that
box on the report.

Any help would be appreciated.

Thanks

Frank Wagner
Click to expand...


.
Click to expand...
 
Back
Top