Copy data back into table

Hi,
I am battling with some simple syntax, i am querying  a table, and have certain records from that Quesry. I need to now copy and insert these records back into the table and change a date column
this is what i am trying but battling to get it running


INSERT INTO tblACISector VALUES (
SELECT '2008/07/30' as QE_Date , tblACISector.SectorCode, tblACISector.SectorName, 'RO' as recSource
FROM         tblACISector INNER JOIN
                      tblQE_Dates ON tblACISector.QE_Date = tblQE_Dates.QE_Date
WHERE     (tblQE_Dates.CurrentFlag = 1))


thanks