Hi,
I have two tables with about 6,000 records each that are *supposed* to be identical. But there are claims that one was tinkered with in the past, and so I've been asked to compare the two tables and see if there are any differences, and if so, what are they. Each table has identical field names.
I've searched this forum and all over the web for how to do this, and what I've come up with is:
-Unmatched Query wizard: When I set up and run this, all it's doing is returning every single record as "unmatched." That doesn't explain what the differences are or really help me at all
-Find Duplicates Query: I thought I could do this and then by process of elimination - the nonduplicates would be "unmatched." However there is a limit of 10 fields to check and I have like 44. Even if it did work it wouldn't tell me the differences in the unmatched fields anyhow.
-Regular Query: Tried to set up a regular design query and put in the Criteria "<>[other table]![same field name]" but then I need to cascade these down under the "Or" so it is stepped and I run out of "Or" rows. This probably wouldn't help much either because what I REALLY need is:
Something that outputs:
The ID number (Primary Key) of the unmatched record, and the value of the unmatched FIELD from each table--which could be multiple unmatched fields for each record.
I found a couple of downloads online for programs that do this but cost $. There must be some way to do it in Access...right?
I have two tables with about 6,000 records each that are *supposed* to be identical. But there are claims that one was tinkered with in the past, and so I've been asked to compare the two tables and see if there are any differences, and if so, what are they. Each table has identical field names.
I've searched this forum and all over the web for how to do this, and what I've come up with is:
-Unmatched Query wizard: When I set up and run this, all it's doing is returning every single record as "unmatched." That doesn't explain what the differences are or really help me at all
-Find Duplicates Query: I thought I could do this and then by process of elimination - the nonduplicates would be "unmatched." However there is a limit of 10 fields to check and I have like 44. Even if it did work it wouldn't tell me the differences in the unmatched fields anyhow.
-Regular Query: Tried to set up a regular design query and put in the Criteria "<>[other table]![same field name]" but then I need to cascade these down under the "Or" so it is stepped and I run out of "Or" rows. This probably wouldn't help much either because what I REALLY need is:
Something that outputs:
The ID number (Primary Key) of the unmatched record, and the value of the unmatched FIELD from each table--which could be multiple unmatched fields for each record.
I found a couple of downloads online for programs that do this but cost $. There must be some way to do it in Access...right?