Allen Browne Audit Log

[David]

Allen

I have been testing the log with no problems. However, it is time to do
something with the data in the log table. But with no examples of how to
use the data in the audit table on the website, could I ask if you could
give some examples of how to extract the data from the table to a form
/ query so that the data could be read in a user friendly way.

To start with, I would just like to be able to display the fields that had
been changed by a user in each record.
From ABC To XYZ by user x on date/time

Any help would be appreciated.

Dave

I hope people will not take this as x posting. Read Allen Browne website and
this was one of the suggested groups.

 

[Allen Browne]

The article at:
http://allenbrowne.com/AppAudit.html
explains how to record two records for an edit: one containing the old
values ('EditFrom') and the second the new values ('EditTo').

If you want the two records to be combined into one, you could use a
subquery to identify the first EditTo record after the EditFrom for the same
key value and the same user.

If subqueries are new, Microsoft's introduction is:
How to Create and Use Subqueries
at:
http://support.microsoft.com/?id=209066

 

[David]

Hi, Allen

Thank you for the reply, I will do some more reading.
I may be back.

Thank you again.
Dave