Help Allen Brown!!!

[Tony Williams]

Sorry to post this at you directly Allen but I posted this on the 5th and
have been unable to get any success. Would you be good enough to consider
this post and point me in the right direction. Your routine is just what I
wanted, but as I have so many fields I need to slim down the report.

Here is my original post:

I have successfully integrated Allen Browne's Audit Trail routine into my
database and it works fantastically well. A BIG thank you Allen!!!!

The routine logs the original value and the amended value and creates a
table with ALL the table's fields and shows the before and after values on
separate rows in the table. My table has about 30 fields and I would like to
produce a report based on a query that only shows the amendments. Can anyone
help me with the criteria that I put in the query that looks at every field
and only shows the fields that are changed?


Can you help?
Very much appreciated
Thanks
Tony

 

[Allen Browne]

Simplest solution would be to use the HideDuplicates property of the text
box in your report to suppress the value in the text box if it is the same
as the box before.

If that suppresses too much, this might help:
Hide duplicates selectively
at:
http://allenbrowne.com/casu-21.html

A completely alternative approach would be to use a subquery that matches
the EditFrom record to the EditTo (excluding Inserts and Deletes of course.)
You can then compare field-to-field between these 2 records.

If subqueries are new, see:
How to Create and Use Subqueries
at:
http://support.microsoft.com/?id=209066

 

[Tony Williams]

Thanks Allen, really appreciate those tips. It's a great routine and as a
novice saved me a great deal of anguish. If I was closer, I'm in the UK, I
would by you dinner!!!!
Thanks again
Tony