Tracking changes

[Guest]

Hi,

Here is the situation:

1. 6 fields that are 2 digits each
2. 1 check box field named "changed"

What I would like to do is track how many times someone changes data in any
of the 6 fields; right now, they would just check the "changed" box (don't
want to trust that). I would like to do something that would give me a count
of these changes.

This way, I can report the percentage of changes within this database.

Any help on this would be appreciated.

Thanks.

 

[Allen Browne]

Access does not provide you with logging, but if all changes are made
through a form, you can use the events of the form to track inserts,
changes, and deletions of your records.

If you are comfortable with VBA code, see:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

 

[Guest]

Thank you very much for your input. I will try this solution and report
back....