change a value back to the default value after one year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a number value set to 1 as the default value. This number changes
during the year. But I wanted this value to go back to it's default value (1)
after one year.

Please help
 
Have a DateCreated field that defaults to Date() and then in you Autoexec
macro run an update query that update all of your number field to 1 if
DateCreated field < Date()-365.
 
Back
Top