Completion Date

  • Thread starter Thread starter fajita
  • Start date Start date
F

fajita

Is there a way to write a code that would automatically
kick out tasks after a completion date has been entered?
maybe after a year? Would it be logical to create a query
by date, and then delete?
 
Is there a way to write a code that would automatically
kick out tasks after a completion date has been entered?
maybe after a year? Would it be logical to create a query
by date, and then delete?
Click to expand...

Could you explain "kick out"?

Certainly, you could write a Delete query with a criterion of

< DateAdd("yyyy", -1, Date())

on the date field; when it's run it will delete all records older than
one year.

However - unless you have millions of records in the table, you may
want to consider keeping the history. Deletion is irreversible; once
it's deleted it's gone forever... and three days after you delete it
the boss is likely to come in and say "Give me a report of the time to
completion of all tasks for the past four years, things seem to be
taking longer lately..."
 
Back
Top