Simple Column Total on Report

[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

 

[Duane Hookom]

View the Report Header and Footer. Then place your sum text box in the
Report Footer section.

 

[Frank Wagner]

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

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

.