change a value back to the default value after one year

S

SCB

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
 
K

KARL DEWEY

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.
 
Top