Group by Name, Sort by Count

[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

 

[strive4peace]

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
*

 

[adam.vogg]

Thank you so much, your answer worked great. You would think that
access would have a more intuitive way to do this ;-)

 

[strive4peace]

Hi Adam,

you're welcome

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

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
strive4peace2006 at yahoo.com
*

 

[newagain]

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
*

 

[newagain]

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.

 

[strive4peace]

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
*