Report from Audit Trail

[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.

 

[Jeff Boyce]

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]

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.

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

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.

 

[Allen Browne]

You could use a subquery to identify the value of the field from the
previous record (same time or earlier.)

If subqueries are new, here's an intro:
http://allenbrowne.com/subquery-01.html

 

[Alan]

ThanksAllen, that has worked a treat!

You could use a subquery to identify the value of the field from the
previous record (same time or earlier.)

If subqueries are new, here's an intro:
http://allenbrowne.com/subquery-01.html

 

[benedito]

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.