-
Need Help With Cross tab query
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??.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|