I have a macro that runs consecutive queries. The third query makes a table that sums a column. It automatically changes the name of the column from Hours to SumofHours. So before the next query(union) can run correctly I need to rename the colunm in the created table.
So in the macro action after the make-table query, but before the union query, I am trying to include an action that will rename the column back to hours.
Thought I would try the RunCode action and write a function to rename the column. But I have never written a function so I was wondering if someone could tell me how to include this in my macro.
At the bottom, I put function name to: RenameFunction().
From there I don't know where to go to actually put in the code or what the syntax would look like?
Can someone please get me started in the right direction?
Thank You.
So in the macro action after the make-table query, but before the union query, I am trying to include an action that will rename the column back to hours.
Thought I would try the RunCode action and write a function to rename the column. But I have never written a function so I was wondering if someone could tell me how to include this in my macro.
At the bottom, I put function name to: RenameFunction().
From there I don't know where to go to actually put in the code or what the syntax would look like?
Can someone please get me started in the right direction?
Thank You.
