Sum a count total

[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

 

[Tom van Stiphout]

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

 

[Duane Hookom]

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.