I
ironwood9 via AccessMonster.com
I have a report showing sales data - it is grouped by Region, then Area -
within each area grouping it shows individual sales in detail.
I want the report to show in descending order the highest area in terms of
sales - but when I group in VIEW / SORTING & GROUPING, access asks for
ascending / descending.
I need to go from this:
West Region
Anaheim
East Anaheim .............5
La Palma......................7
Bolsa Chica
Paradise......................3
Almost Paradise .......2
Cucamonga
La Palma ....................97
to something like this - Cucamonga area is shown first, because it's sales
are highest
West Region
Cucamonga
La Palma ....................97
Anaheim
East Anaheim .............5
La Palma......................7
Bolsa Chica
Paradise......................3
Almost Paradise .......2
within each area grouping it shows individual sales in detail.
I want the report to show in descending order the highest area in terms of
sales - but when I group in VIEW / SORTING & GROUPING, access asks for
ascending / descending.
I need to go from this:
West Region
Anaheim
East Anaheim .............5
La Palma......................7
Bolsa Chica
Paradise......................3
Almost Paradise .......2
Cucamonga
La Palma ....................97
to something like this - Cucamonga area is shown first, because it's sales
are highest
West Region
Cucamonga
La Palma ....................97
Anaheim
East Anaheim .............5
La Palma......................7
Bolsa Chica
Paradise......................3
Almost Paradise .......2