How to control order of crosstab results

[Phil Smith]

I have a crosstab, with the Column Heading "Size". Results are various
combinations of "X-Small","Small", Medium", "Large", "XL", XXL...etc.
This does NOT sort by human needs, but alphabetically.

Within the data, I have a numerical field for "Size Order" which I can
use to sort by and get everything to come out neatly, except for Crosstabs.

Is there a simple way to have the tabbed columns sort based on this
other field, other than concatenating it to "Size?"

Thanx

 

[KARL DEWEY]

In the PIVOT statement add this just before the semicolon --
IN ("X-Small","Small", "Medium", "Large", "XL", "XXL", ...etc.)
listing your sizes in the order you want to position them as column headings.