I am passing a sql statement for a crosstab query, as such, in VB Code:
___________
strSQL = "TRANSFORM....
"SELECT ....
"FROM .....
"WHERE....
"GROUP BY ....
"PIVOT myField IN ('Apple', 'Orange', 'Banana')
CurrentDb.QueryDefs("myQuery").SQL = strSQL
____________
If I look at the ColumnHeading property in design, it's set to 'Apple', 'Orange', 'Banana'
The query in Access however is sorting as such... Banana, Orange, Total, Apple
Why isn't my PIVOT IN line sorting the column headings in the order I want!?!?
Thanks for your help!!
___________
strSQL = "TRANSFORM....
"SELECT ....
"FROM .....
"WHERE....
"GROUP BY ....
"PIVOT myField IN ('Apple', 'Orange', 'Banana')
CurrentDb.QueryDefs("myQuery").SQL = strSQL
____________
If I look at the ColumnHeading property in design, it's set to 'Apple', 'Orange', 'Banana'
The query in Access however is sorting as such... Banana, Orange, Total, Apple
Why isn't my PIVOT IN line sorting the column headings in the order I want!?!?
Thanks for your help!!