Difference Reports

[Rudy IP]

Say I have two tables, which were created by the same
query. However, the data the queries run off has changed
a bit. For instance, a record has been added, and the
data in some of the fields has changed for a few records.
An example would be a table where the records
are "employees" and a field is "salary". Some employees
have left, and some employees have recieved raises. How
is it possible to find out the changes in the employees
and salary that take place from time to time? Is it
possible to use a query to create a difference report of
two tables?

 

[Michel Walsh]

Hi,

The Replication generally tracks those changes, so a possible start
would be in reading the replication tables, once the replication is
activated. On the other hand, since Replication is not thought in the
objective of "human" tracking, the User Interface is non-existent... that
would require quite some work.


Hoping it may help,
Vanderghast, Access MVP