Calculating totals in a report in Access 2007

  • Thread starter Tony No Baloney
  • Start date

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