Copy records with new date in the same table

[kunguito]

I want to copy all records (preserving the old ones) from a certain date (a combination of month and year) with a new date.

Here's what i've worked out.

INSERT INTO TABLE ( Field1, Field2,Field3, Month, Year)
SELECT TABLE.Field1, TABLE.Field2, TABLE.Field3 FROM TABLE
WHERE (((TABLE.Month)=[OldMonth]) AND ((TABLE.Year)=[OldYear]));

But obviously I'm not feeding in the new month values.

[CreganTur]

Are you saying that you want to update all records with a specified date with a new date? If so they you want to use the following Syntax:
[VBA]UPDATE Table SET Table.FieldName = DesiredResult[/VBA]

You can add in WHERE clauses as usual, along with anything else you may need.

[Solo_TA]

You are very close. I would use following command:
INSERT INTO TABLE ( Field1, Field2,Field3, Month, Year)
SELECT TABLE.Field1, TABLE.Field2, TABLE.Field3, NewMonth, Newyear
FROM TABLE WHERE (((TABLE.Month)=[OldMonth]) AND ((TABLE.Year)=[OldYear]));
where NewMonth and NewYear are new date

[kunguito]

Yeah! Wasn't so difficult, was it?

Thanks dude!