Calculating a total in a report

Y

Yvonne

I have one column that I would like the grand total to print in the footer
section of the report. Can you tell me the correct expression to use and if
I can do this in report design view?
 
D

Duane Hookom

Add a text box to the Report Footer section and set its control source to
something like:

=Sum([YourColumnName])
 

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

Group Totals and Grand Totals on each page 3
One and One-half Columns and Grand Total on Same Page (?) 5
Grand Total for a calculated column - Access 2007 1
Report Footer Grand TL not appearing on one page report with colum 4
Shading Header / Footers and separating all rows with lines; weird whitespace 0
Report Grand Total Miscalculating Overtime 5
A03 - count in report footer gives me #Error? 0
Report Footer 3

Top