Find Updated Records

[JillT]

I need to automatically weed records from a database. My user wants to find records which have not been updated or modified for one year.

I could add an extra field to the table to insert a date whenever the record is modified and base a search on this field, but there must be a better way (mustn't there?)

 

[JimHorton]

Jill,
Unfortunately, no, there mustn't. The timestamp field is the generally accepted method for this. Access, without table-level triggers, requires care in making sure this field is maintained, ie if you let users open the table 'raw', and change data, this method is then rendered inaccurate.
--Jim

 

[MichaelRed]

Some 'other' isues will also arise to impede your progress.

Network clock synchronization (or lack thereof) can be a hidden hinderance to having your way really work.

Also, you need to be careful to introduce the date as of the first save of the record.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over