Report from Audit Trail

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I am using Allen Browne's audit trail to great effect. However, I am trying
to write a query to extract the changes of a certain field into a report. My
problem is that whenever anything changes a new record is created in the
auddata table but the Status field which I want to report on may not be the
field that has changed. I want to show only the Status field as it changes
in order ot have a 'timeline' of changes. Can anyone help?

Many thanks,

Alan.
 
While I haven't used Allen's audit trail, I'm going to guess that one of the
fields recorded is the name of the field changed. If so, could you use a
query to find all change records where [FieldChanged] = "Status"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi Jeff,

Thanks for your prompt response. I'm fairly new to this so not too hot on
writing code. Would you have an example?

Thanks again,

Alan.

Jeff Boyce said:
While I haven't used Allen's audit trail, I'm going to guess that one of the
fields recorded is the name of the field changed. If so, could you use a
query to find all change records where [FieldChanged] = "Status"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Alan said:
I am using Allen Browne's audit trail to great effect. However, I am
trying
to write a query to extract the changes of a certain field into a report.
My
problem is that whenever anything changes a new record is created in the
auddata table but the Status field which I want to report on may not be
the
field that has changed. I want to show only the Status field as it
changes
in order ot have a 'timeline' of changes. Can anyone help?

Many thanks,

Alan.
Click to expand...
Click to expand...
 
Alan said:
I am using Allen Browne's audit trail to great effect. However, I am
trying
to write a query to extract the changes of a certain field into a report.
My
problem is that whenever anything changes a new record is created in the
auddata table but the Status field which I want to report on may not be
the
field that has changed. I want to show only the Status field as it
changes
in order ot have a 'timeline' of changes. Can anyone help?

Many thanks,

Alan.
Click to expand...
 
Back
Top