Sorting Reports & Combining categories

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I have a report that I need to sort by customer type and alphabetically by
name.

We have three customer types, let's call them A, Bsub1, and Bsub2. I would
like to sort these customers into groups by their type and then
alphabetically, but would like to combine Bsub1 and Bsub2 so that we have
them in one group. Thus, the report would have group A and Group B (and each
customer in group B will still be sorted alphabetically regardless of their
sub type). Is this possible?

Thank you for your advice!
 
Mary,
In the report design toolbar there is a "Sorting and Grouping" icon. If you
click on that it will let you group or sort accordingly. Group by Type and
sort by customer name. I think that will do what you want it to. You can
also choose the intervals that you want to sort by.

J
 
Are there just the three types. If so, use a calculated expression to
group by (or sort by)

=IIF([Type]="Bsub1" or [Type] = "Bsub2","X","A")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
You can enter a sorting and grouping exression like:
=([Customer Type]="A")

This would create two groups.
 
Back
Top