Dates that rollover year to year

[JMS]

I am working with a project/workflow database. I want to be able to rollover
dates in certain fields on selected tables. How can I rollover dates such as
3/4/08 to 3/4/09?

 

[John W. Vinson]

I am working with a project/workflow database. I want to be able to rollover
dates in certain fields on selected tables. How can I rollover dates such as
3/4/08 to 3/4/09?

Roll over from where to where?

You can insert a new record in a table using an Append query, using an
expression like

DateAdd("yyyy", 1, [fieldname])

to calculate a date one year in advance of the date in fieldname.