I have a database that contains 13,772 records and each record contains 34 fields. The database is used for historical research purposes. As I am constantly changing the content in one or more fields I would like to be able to have a field that would show the date of any changes that are made to any of the fields in any given record. Additionally I would like to be able to run a query, lets say every six months and extract all the updated records. Any offers of advice on how to proceed would be very much appreciated. Thanks in advance.
Automatic date entry for field changes.
0 commentaires:
Enregistrer un commentaire