General :: Sort By 2 Columns

I am trying to sort by 2 columns

1st column by "type"
2cnd column by " stock number"

I have the query set to ascending in both fields but it will only do the type columnexample below shows 5096B00028 not together

Quote:

requistion items stock number Material type: 5096B000335 9mm x 33.5mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B00028 9mm x 28mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B00114 9mm x 114mm winding core 5mm A/F hex Rynite 935 (to dwg 9020) Core 5096B000675 9mm x 67.5mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B00057 9mm x 57mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B000355 9mm x 35.5mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B00028 9mm x 28mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B000335 9mm x 33.5mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core 5096B00049 9mm x 49mm winding core 5mm A/F hex Polypropylene Adstif HA840R Core