kunguito
10-23-2008, 01:23 AM
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.
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.