How can I Move data from one column to another in my access table?

I have two columns, one that stores current month’s data and one that stores last month’s data. Every month data from column 2 (this month’s data) needs to be moved to column 1 that holds last month’s data. I then null out column 2 so I can accumulates this month’s data.

I understand how to drop a column or add a column, how do I transfer data from one column to another.

Here is my trial code:

<cfquery name="qQueryChangeColumnName" datasource="#dsn#">

  ALTER TABLE leaderboard

  UPDATE leaderboard SET  points2 = points3

</cfquery>

Unfortunately, I get the following error:

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.

How can I transfer my data with the alter table method?