Compare 2 records and Only print the fields that have changed ?

  • Thread starter cw via AccessMonster.com
  • Start date
C

cw via AccessMonster.com

I'm using Allen Browne's Audit code in my database.
All changes made to my database are logged into the audCP table by CPID (this
is the record ID).
See Allen's link if needed: http://allenbrowne.com/AppAudit.html
(by the way, his code works perfectly.)

How do I query the Audit table & View or Print just the FIELDS that have
changed?

Here's a sample audit record:
----------------------------------------
audID ID audType audDate audUser Acct CustomerName VRZPr CWPair
CRV Type
1631 142 EditFrom 11/29/05 jalex 3725 BAD Port 398
svf0-9-48 480 2
1632 142 EditTo 11/29/05 jalex 3725 John Doe
398 svf0-10-48 480 4
----------------------------------------

I'm not sure what expression to use in my Query/Report to get the audited
records:
a) The original unchanged record (EditFrom)
b) The updated one (EditTo)
c) A way to Highlight the Field that was changed?

This audit table is very exhaustive & after awhile it gets hard to see
exactly what changed, so it would be great to have a query or report to show
the changed details more easily.

Thanks,
cw
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allen Browne Audit Log 9

Top