Monthly Archive

what i'm trying to do, is to create table identical to "faults" and move all of last months entries into the new archive table.
the current SQL i have is

SQL = "CREATE TABLE "
SQL = SQL + Left(Date, 2) & ":" & Left(Right(Date, 7), 2) & ":" & Right(Date, 4)
SQL = SQL + " AS(SELECT *"
SQL = SQL + " FROM Faults"
SQL = SQL + " WHERE (((Month([DateAdded]))=Month(Date())-1));"

the error that appears is... "Error 3290 - Syntax Error in CREATE TABLE statement"

can you work out whats wrong?