columnheadings

[Guest]

How can i use visual basic editor to change the columnheadings setting of a "cross query"?
I tried,
myQuery.columnheadings = "fields1
but it seems not ok......

 

[Michel Walsh]

Hi,


You edit the SQL text, it is in the IN list in the PIVOT clause:


" TRANSFORM.... PIVOT expression IN('a', 'b', 'c' ) ; "

has the 'fixed' columns a, b and c




Hoping it may help
Vanderghast, Access MVP

 

[Guest]

But can i change this setting with VBA??

 

[Duane Hookom]

Currentdb.QueryDefs("qxtbYourQuery").SQL ="what ever pivot whatever"