need sub summary help

[cet]

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?

[LaRetta]

You need two leading parts. One to contain your field Shirt/Pants. The next leading part to contain the sizes.

Sort first by shirt/pant field, then by size.

[cet]

I am still not doing something correctly. I still got the same result.

[MoonShadow]

is there any way to sort by two fields consecutively

Open your sort dialog. You can add as many fields as you wish and specify (per field) whether to sort ascending or descending.