Sum in Reports.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to calculate the sum of a column in a report and display it in
the report itself. How do I do that?
Thanks
 
If you are summing for the entire report, create a text box in the report
footer to hold the sum of the column. The Control source of the text box
should be Sum([ColumnTextBoxName])

[ColumnTextBoxName] should be the name of the text box that has the values
you want to sum.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating page/report sums using calculated data from subquery 6
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Summing a column in a report 5
Report Footer Sum 1
Running Sum Overall and different views 2
Report with 2 Subreports 1
sum error 2
Summing in a Report Footer 7

Back
Top