Calculating totals in a report in Access 2007

  • Thread starter Thread starter Tony No Baloney
  • Start date Start date
T

Tony No Baloney

I am using Access 2007 to create reports.

For the query, I am pulling a first name, last name, company,
division, and dollar amount.

All the data is being pulled correctly in the query and the report.

I would like to have a total dollar amount for each company.
How would I go about doing this in my Access report?
 
Do you have a Sorting and Grouping level on Company? If so, you can
display the group footer and add text boxes with controls source like:
=Sum([Dollar Amount])

If you want the company totals to appear one after another in a
'list', then you may need to create a subreport with the company
totals and insert the subreport into the main report.

Duane Hookom
MS Access MVP
 

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 2007 Report shows multiple rows, query shows single row 0
Printing report for Invoice 0
Batching Totals in Groups of 25 - How? 12
Calculating Percent of a Group in Report Footer 2
Totalling Expr1 in a report 1
Access Report on Parameter Query 3
Trouble with my sorting and grouping 2
Errors in Report total fields 19

Back
Top