Is there a way to also copy the values from the 97 column while creating the new column (field) or after the column(field) is created a simple way to copy & paste all the values from column 97 to column 98, using VBA.
I can open up the table select the entire column 97 click copy & then paste this into column 98 but cannot see how to do this via VBA.
Please help not done much programing before & Im going mad here.
Now this works is there a way to set the  &  from a global variable, I have a global variable called =selected_Cost_Set() & =selected_Cost_Set2()that has a number value in it i.e. 98 which will increment every month, is there a way to add this variable into the SQL Query.