I'd like to Insert values from one Access Table into another
as well as a literal string value

My statement is as follows
Say Table 2 has one field: Sales
Table 1 has two fields, Month and Sales
I'd like to insert 10 into the month field of
table1 as well as the sales value from table2

This is how my statement looks thus far.
It produces an Insert into error.

Insert into TABLE1(Month,Sales)
Select "10" as Month, Sales from Table2

Thanks in advance.