Need help in script level

[#1]

Hello Friends,

I have a field names in the table like the following.

Month1, Month2, Month3, Month4, Month5 etc...

My requirement is, is it possilble to rename the column names in the script like display as Jul 2012, Jun 2012 etc....

Month1  as Monthname(today(),-11)

Month2 as  Monthname(today(),-10)

.......... etc..

Regards

Chriss

[giakoum]

please see attached for a possible solution

[hallquist_nate]

Have you tried using the Cross Table function in the File Wizard?  That is another option, as it appears that is how your data is structured.

[#4]

Dear Loannis and Nate

Thanks for your reply but I can not relate the month name, the ultimate aim is need to draw line chart that will show the month name and sum of  (KPMN01).

I have attached the work file.

could you please give a idea how to proceed....

Regards

Chriss

[hallquist_nate]

Is Month1 always the current month, or do you have a year field stored somewhere?

[giakoum]

The work file was not attached. Please retry!

[#7]

Sorry Loannis,

Yesterday net is down not able to attach the file.. please find the attached

Regards

Chriss