Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
order by clause in cross tab
- Thread starter VBmim
- Start date
Databaseguy
MIS
Not directly.
What you can do though, is create a regular select query, and include the column names from the crosstab in the select query. Then sort by whatever field you would like.
The only drawback to this approach is maintaianance becomes a nightmare.
Tyrone Lumley
augerinn@gte.net
What you can do though, is create a regular select query, and include the column names from the crosstab in the select query. Then sort by whatever field you would like.
The only drawback to this approach is maintaianance becomes a nightmare.
Tyrone Lumley
augerinn@gte.net
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question