update queries

[slowhand]

I would appreciate help on the following.
My table "Relations" have 365 entries which are dates from 01.01.2001 to 31.12.2001.
Is it possible to create one update query which will then update all the values to the same values but for year 2002?
Thanks

 

[raskew]

Not a problem.

Try something similar to this:

UPDATE tblMyDate SET tblMyDate.MyDate = DateSerial(2002,Month([MyDate]),Day([MyDate]));

All the values that might be present in
tblMyDate remain the same--only the dates
change.