how can I compare two subsequent revisions of large tables of ide.

A

Andy Wright

I need to compare two subsequent revisions of Access2000 tables. The later
revision can have added/deleted records whcih I can find with query wizards,
but I also need to identify speific changes within a record and produce a new
output table with 7 fields which detail the record ID, the before and after
values and field name which has the changes. If anyone can help I can
provide a more detailed and clearer explanation in an example table.
 
Top