Sum a count total

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

Hi,

I have a query that shows the following information

It looks at a specific table (table 1) then groups by sales agent, then
groups the tariffs that have been sold by that sales agent and then the query
has a count on tariffs. I have then built a report to display the results
which would look like this :-

Dave Brown
Standard Tariff 1
EDP Tariff 2

What I want is a nother function in the query that will then sum the count
coloumn so the example above the sum coloumn would be 3. i then need the
report to sort by the sum.

Thanks
 
On Wed, 28 Apr 2010 05:39:01 -0700, Glenn

I would create that sum total in the report footer, not in the query.
Create a field in the footer and set the ControlSource to:
=sum(myCountOfTariff)
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP
 
IIRC, there are situations where a report will not sort on a value derived
from a subquery. If this happens, you may need to create a totals query and
join it to your report's recordsource query.
 
Back
Top