Group by Name, Sort by Count

  • Thread starter Thread starter adam.vogg
  • Start date Start date
A

adam.vogg

I have a report where I want to Group by the CallerName, but then sort
by the Number of Calls. Using the sorting/grouping, if I group by
CallerName then it wants to sort them. If I put the NumberOfCalls in
the sorting/grouping, it groups on the values of it, so if a couple
callers have the same number of calls, it only shows the first
instance.

Basically I want the output to look like this:

Mike 25
Bill 20
Chris 20
Steve 10



The only way I can get it is either alphabetical by caller, or if I
sort by the number of calls, it groups them and it wouldnt show "Chris
20" above since the 20s would group.

Any ideas?

adam
 
Hi Adam,

sort by Number of Calls (no group header or footer), then GroupBy Name

turn on the sorting and grouping box in the report design:

from them menu --> View, Sorting & Grouping

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Thank you so much, your answer worked great. You would think that
access would have a more intuitive way to do this ;-)
 
Hi Adam,

you're welcome :)

.... that depends on your perspective <g> ...

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
strive4peace2006 at yahoo.com
*
 
strive4peace said:
Hi Adam,

sort by Number of Calls (no group header or footer), then GroupBy Name

turn on the sorting and grouping box in the report design:

from them menu --> View, Sorting & Grouping

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
Click to expand...
 
Hi,

I have a similar problem but have only one field to work with: rmedia. This
holds a list of items of where a client heard about the company. I'd like to
be able to count how many of each but only show one instance of the name.
Similar to Adam:

newspaper 4
billboard 5

Thanks.
 
Hi,

Group By --> rmedia

put rmedia in the detail section, but don't show it
(click on the Detail section bar and set the visible property --> No)

then, in the rmedia footer or header, make 2 textbox controls and delete
the assoiated labels

ControlSource --> rmedia

ControlSource --> =count(*)


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top