A
Adam Pedder
I have two tables, one with an original set of data and another produced
programmatical that should be the same.
Unfortunately it is not. I am trying to work out how to find what records
are different. There are over 12,000 records in total, so don't really want
to do it manually!
There are a couple of complications:
Firstly the table is unique over several fields.
Secondly I am not interested in the actual duplicates, I've managed a query
to get the. I need the unique records.
I've found a couple of newsgroup articles but they always seem more
concerned with deleting duplicates rather than leaving the non-duplicated
records. Any suggestions would be welcome.
Thanks,
Adam
programmatical that should be the same.
Unfortunately it is not. I am trying to work out how to find what records
are different. There are over 12,000 records in total, so don't really want
to do it manually!
There are a couple of complications:
Firstly the table is unique over several fields.
Secondly I am not interested in the actual duplicates, I've managed a query
to get the. I need the unique records.
I've found a couple of newsgroup articles but they always seem more
concerned with deleting duplicates rather than leaving the non-duplicated
records. Any suggestions would be welcome.
Thanks,
Adam