Total fields by Section 1

[Sadukar]

Hi all

How do I total fields in a report depending on there section

For Example
From a query like this.

Section M/CCode Hours
Elec M/C1 2
Elec M/C2 1
Meca M/C3 5
Meca M/C4 2
Prod M/C5 3

I want to total the hours by the section.
For Example
Section M/CCode Hours
Elec M/C1 2
Elec M/C2 1
total 3

Meca M/C3 5
Meca M/C4 2
total 7

Prod M/C5 3
total 3

Any help would be appreciated
S.

 

[CosmoKramer]

In your report, group by Section. In the Section group footer, place a text box with the control source something like this:

=Sum([Hours])

This text box will display the sum of hours for each section.....

 

[Sadukar]

Thanks for the response Cosmo

The footer for my groups isnt showing up in the design mode of the report.
I only have:
Header of report
Header of page
Header of "Section"
Detail
Footer of page
Footer of Report

How do I get it to show up?

 

[CosmoKramer]

In design view, click on View then Sorting and Grouping. In the dialog box, select your Section field under Field/Expression, then under Properties at the bottom, change Group Footer to Yes....