Sum Totals in Reports ?! (1 Viewer)

[John Bull]

Hi everyone
I am quite new to the World of Access(3 months) and I am encountering problems with one of my reports.
I have one column containing prices of invoices. How would I go about adding a Sum total at the end of the report. I need to do this for two columns/variables.

Thanks
John

 

[Richie]

Add a text box to footer set source to =Sum([YourFieldName])

 

[John Bull]

Thanks for the advice.

I tried it out, but when I ran the report,the following appeared:
#Error
Are there any solutions??

Thanks
John

 

[accesswatch]

Some points to look for
Make sure you are using the Field name and not the control name in your SUM
You can only use SUM for groups and Report totals. You cannot use them for page totals (Work round available for this see below)
You cannot SUM a calculated column directly.

Try these KB articles
How to Sum a Calculation in a Report: http://support.microsoft.com/support/kb/articles/Q129/0/96.asp

and

How to Sum a Column of Numbers in a Report by Page: http://support.microsoft.com/support/kb/articles/Q132/0/17.asp

Hope this helps
Regards
trevor from www.accesswatch.co.uk

 

[Ron Bell]

Reports text boxes have property 'Running Sum'
No,Over Group, Over All
Try Over Group if yr Sum is in Group footer
Try Over All if on Report Footer

 

[John Bull]

thanks for the above suggestions, it's working now.
The reason was that I was putting the box in the page footer and not the report footer.