Clear fields on certain date

[alguzman]

How can you have your table clear some fields exacly one year from now.

 

[jwindon]

Use a delete query with criteria set to check the DatePart function against the date in the date field.

 

[Pat Hartman]

You should not be storing this data. You should be calculating it. Review the definitions for 1st, 2nd, and 3rd normal forms. An attribute (column) should depend ONLY on the primary key of the table. It sounds like the colum you want to clear depends on the system date in relation to some other date in the table.