Sorting & Grouping question(Sort descending based on overall count

[Ricardomw73]

Hello all, I have an access report I am working where I need to sort
different tiers/layers and they all need to be sorted in descending
order based on the overall count. I am working with data in the
following format.

Tier1 Tier2 Tier3 #
sometext7 sometext8 sometext9 5
sometext1 sometext2 sometext3 10
sometext1 sometext2 (blank) 2
sometext1 sometext2 sometext4 15
somtextt10 sometext11 sometext12 2
sometext1 sometext5 sometext6 6

Hoping to achieve an Access report in the following format
------------------------------------------------------------------------------------
# Tier1 # Tier2 # Tier3
33 sometext1
27 sometext2
15
sometext4
10
sometext3
2
(blank)
6 sometext5
6
sometext6
5 sometext7
5 sometext8
5
sometext9
2 sometext10
2 sometext11
2
sometext12

Each time I tried to change the sort order it would sort by the name
of the tier instead of the count for the tier. I am grateful for any
help on this.

Thanks

 

[Duane Hookom]

It isn't clear what you are asking for. If you want to sort by an aggregated
(sum, count, ...) value from your report, then you must get that aggregated
value into the record source of your report. This is generally accomplished
by creating a totals query that aggregates your records and calculates the
appropriate value. Then add this totals query to your report's record source.

 

[Ricardomw73]

Hello, Duane

Thank you for the reply, I went back and created 3 total queries(1 for
each tier\level) and then joined the 3 queries together to get the
information into the report and it is working like a charm now.

The spacing when trying to illustrate something is jacked up, "what
you see is not what you get"

Thanks again