I have a DB listing shirt sizes and pants size for 400 records. The sizes are controlled by a value list using radio buttons. I am trying to do a sub summary showing how many of each size I need. When I do a sub summary by shirts and pants I get the following breakdown.
Shirts: YS 4 YM 6
but then I get the following breakdown for the pants:
Pants: YS 4 YS 3 YM 3
I want the pants to display as YS 7 YM 3.
I know that it has to do with my sort order but is there any way to sort by two fields consecutively?
