The website http://allenbrowne.com/tips.html
is a well known one for access guidance.
There is a standard bit of code here that provides audits for table changes.
I seek an enhancement to this code - does this exist??
The standard audit in the site give the value of ALL fields prior to a record change.
It also gives the value of ALL fields after a record change.
I would like a bit of code that analysed the records in the audit table and then identified which SPECIFIC fields changed.
i.e. the audit table simple shows ALL fields in the record. I just want to report on those that changed.
If you are not familiar with this audit then it may be difficult to comment.
The bottom line is that I am wondering if someone has already written the code I want. I.e. I do not want to re-invent the wheel (actually I am not really capable of doing s