Getting Query Field Total Into Report

  • Thread starter Thread starter stillcrazee
  • Start date Start date
S

stillcrazee

Have a field (column) in a query, and I need to have the total of that
field be a "Grand Total" (report footer) in a report.
 
Hi stillcrazee

Put a textbox in your report footer

Set the controlsource to:

=sum([nameoffieldtosum])

That should do it

Debra
 

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

Access MSACCESS - Sorting report based on field calculated in the report 0
Total cost stored in a field 2
Problems with Totaling 1
One and One-half Columns and Grand Total on Same Page (?) 3
Can't calculate Grand Total of several other expressions 1
Total in form 1
Totals and Subtotals 1
Delay in getting subform total to calculate 2

Back
Top