Dates in Update Queries

[Mike Comtois]

Is there a way to run an update query to update to update
a date field to a specific date of THIS year?

For example, If I run the query now it will update all
the dates to 3/10/2004 and if I run it in one year,
without changing anything it will update the date to
3/10/2005.

Any help would be great! Thanks!

 

[Duane Hookom]

UPDATE tblYourTable
SET [DateField] = DateSerial(Year(Date()), Month(DateField),Day(DateField));