Report header group subtotal - shows over not under

[vipersmind]

Hi
I have a report coming of off this table

tblDrill_MnthCosts
Year
Zone
Coresize
Metres
DrillCosts

I have grouped by the Year and Year and am trying to
sum([metres]) and sum([DrillCosts]) for each Year. To do this I put a control in the Year Header. It sums both fields for the Year but they show up on top of the metres and DrillCosts fileds, not under.
Why is this so ?
Pic attached.

Thanks for your help

 

[Rich]

Use the Group Footer

 

[vipersmind]

cheers

Thanks Rich
Now you mention it I have used that function before.
Mind spasm I guess.

So much to remember, So little space to fit it.