Problems with totals in a report

[dragginthru]

Im totally new to using reports so sorry if this is obvious!

I have a multi table parameter query that selects the course cost, attendees etc and sorts by GP code (to become an invoice basically) that the user then enters the start/end date of the invoicing period.

My report SHOULD like this


GP CODE 3278585

Mr Smith - Training course a - £300
Mrs Blobby - Training course b - £300
Jane Doe - Training course C - £0

TOTAL - £600

--

GP CODE 3948484

Mr Jones - Training course d - £150
Mrs Smith - Training course C - £300

TOTAL - £450

However I cant get the total to be anything other than the total for ALL the records retrieved by the query so currently every total is £5000 or so!

I copied a box with =sum[charge cost] (thats the field name) but basically the report is not grouping these by GP code.

Everything else on it is correct, its all grouped correctly.

Anyone guide me on what obvious thing i have done wrong?

 

[ThreeCrow]

Do you has your Sum textBox in the GroupFooter or the ReportFooter

 

[dragginthru]

Its in the page footer, so that explains it.

How do add a group footer? my report (which was made by the wizard) has the following bits in design view:

report header
page header
practice_code header
detail
page footer
report footer

No sign of a group footer!

 

[Rich]

Display a footer for the practice_code header

 

[dragginthru]

Sorry to sound like im useless but how do i insert one? I cant find a button or menu option that does it!

 

[dragginthru]

awesome i have it working now

I found the button (Sorting & Grouping on the report design toolbar)

Thanks a lot!