Pietlinden,
Thanks for your reply.
We did it without plan so no id was added. Obviously under such situation,
human being is superior than the computer. We can check line by line to
find out the difference but it is an inefficient way to do. I would like to
use computer to check every fields of records and give me the result of
differences.
Ray
<pi********@hotmail.com> wrote in message
news:11********************@g44g2000cwa.googlegrou ps.com...
okay, so you archived a table, and then you want to see which fields in
your new table have changed... that's all easy... IF and ONLY IF you
have a unique identifier for each record that stays consistent between
archivings. If not, how do you know which record should match with
which? If you cannot do this, this is an unanswerable question.
If the primary keys/unique ID's are consistent then you can write a
little code to query the tables joining on the ID field and using
table1.[field n] <> table2.[Field n]. then you could just write that
information to another table.
If you followed Allen Browne's example of logging changes, you could
find them all that way.