Prev: On Open Event in a report
Next: how to setup event procedure on format?
From: Tony No Baloney on 9 Nov 2009 13:31
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?

From: duanehookom on 9 Nov 2009 17:07
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

On Nov 9, 12:31 pm, Tony No Baloney <tonyrulesy...(a)yahoo.com> wrote:
> 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?

 | 
Pages: 1
Prev: On Open Event in a report
Next: how to setup event procedure on format?