Update query

[marconi86]

I have a some records with the date "mm/dd/2005" and I need to update
the dates to be "mm/dd/2006". I only need to update the year. Any
help on a query to perform this function?

 

[Jeff Boyce]

Would it be enough to add 1 year? If so, take a look at the DateAdd()
function/syntax in Access HELP.

Another approach, but more complex, would be to use the DateSerial()
function to force the year portion to be 2006. (also available via Access
HELP)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Rick Brandt]

I have a some records with the date "mm/dd/2005" and I need to update
the dates to be "mm/dd/2006". I only need to update the year. Any
help on a query to perform this function?

UPDATE TableName
SET FieldName = DateAdd("yyyy", 1, FieldName)
WHERE FieldName >= #2005-01-01#
AND FieldName < #2006-01-01#