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