TRANSFORM Sum(X.OpenQuantity) AS SumOfOpenQuantity
SELECT X.PFamilyCode, X.SalesCode, Sum(X.OpenQuantity) AS [Total Of OpenQuantity]
FROM X
GROUP BY X.PFamilyCode, X.SalesCode
ORDER BY X.PFamilyCode
PIVOT X.ReleaseDate In ('......');

I need help with the In list

The Releasedate is actaully a Text field, since it has dates and text.
I need help on how to sort this in the order required

Possible values :
1. 'ON',
2. 'DLE'
3. '5/7/04'
4. '5/8/04'
......
7.'MAYSe'

etc

I want 'ON' to be first column always, 'DLE' to be the second column, after that is my problem, there could be any number of date values for the next 2 months.
is there a way to list without actually hard coding??.