renaming columns of a crosstab query possible??

[hotmalepiyush]

can i rename columns of a crosstab query??
can u explain using this example..

[FONT=Times New Roman]TRANSFORM Sum(foJUN.OPEN_INT) AS SumOfOPEN_INT[/FONT]
[FONT=Times New Roman]SELECT foJUN.SYMBOL[/FONT]
[FONT=Times New Roman]FROM foJUN[/FONT]
[FONT=Times New Roman]WHERE (((foJUN.STRIKE_PR)=0) AND ((foJUN.OPTION_TYP)="XX") AND ((foJUN.TIMESTAMP)=Date()-1) AND ((foJUN.INSTRUMENT)="FUTSTK"))[/FONT]
[FONT=Times New Roman]GROUP BY foJUN.SYMBOL[/FONT]
[FONT=Times New Roman]PIVOT foJUN.EXPIRY_DT;[/FONT]
[FONT=Times New Roman]

[/FONT]

 

[khawar]

do you want to rename expiry date

 

[hotmalepiyush]

yes.. i want that

 

[khawar]

what name you want for your date columns

 

[hotmalepiyush]

"this_mnth" "that_mnth"

 

[khawar]

can you give example what is the date and what is the name you want for that date