I have a table myTable. It has a field myDateField. There are thousands of records in the table.
I need a query that will update the year portion of the dates in myDateField by adding 4 years. For example, if the value is 6/1/2005, I need to update it to 6/1/2009.