Counting amount of times a record is amended

  • Thread starter Thread starter Jaycee
  • Start date Start date
J

Jaycee

I am trying to set up a form so that when the record is
amended a label with a count of times is changed.
Any ideas would be grateful
Using Access 97
 
You will have to add a column or two to the table
for example, you could timesModified and ModifiedDate,
and update these values each time an update is made.

Alternatively, you could add a history table that stores the previous values
You could then display the sum of amendments for this record on your form

This is a more complicated option but is used in situations where audit
trails are required.

HS
 
Back
Top