T
Tony Williams
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?
Thanks
Tony
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?
Thanks
Tony