Column Headings For Crosstab Query

[dknj30]

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!!

 

[Guus2005]

I don't know.

Please post a sample database so i can try it for myself.