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

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.