How to add fields on a report

[markswan20]

Hi everyone.

I have created a virtual money box for my son and when i generate the report it gives me the list of who gave him what how would i put a single field to add the whole column up so it gives me a total paid all together.

Cheers
Mark

 

[jrbarnett]

In the report footer, create a textbox with the controlsource =Sum([Fieldname])

This will contain the sum of the field in that value over the whole report.

John

 

[markswan20]

Hi John,

The field only seems to be adding a single field i moved the text box into the detail area and it seems to be displaying each total again.

Cheers
Mark

 

[jrbarnett]

Set up a group that covers all records and use the footer section of that group to put the sum total in.

John