Column headings in DYNAMIC crosstab query

[jtoutou]

Hello to everyone!!!

i need to ask something
I CREATE I DYNAMIC QUERY .....HOW CAN I CHANGE THE NAME OF THE COLUMN HEADINGS?
THANX IN ADVANCE

 

[ted.martin]

One way would be to make the column heading like this:

NewFieldName: [OldFieldName]

Anything more complicated that this would require the use of SQL code.