How to control order of crosstab results

  • Thread starter Thread starter Phil Smith
  • Start date Start date
P

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
 
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.
 
Back
Top