Check 2 tables for correctness

[D.Verkissen]

Hi There,

I have a problem i just can't figure out.
I will give you the example in text so you know what i mean.
Exa:

I have 2 tables, talbe 1 and table 2, with the following things.

Table 1:
|Train|Number|
--------------
|Medium|2|
|Large|3|

Table 2:
|Trains|Number|
---------------
|Medium|2|
|Large|4|


As you can see besides the name differs (s) the tables allmost contain
the same data. But that's the point. What i want to do is i want to
compare those to tables with each other in order to figure out where
the data doesn't equal to each other.

As you can see, table 1 row 1 is equal to table 2 row 1. But table 1
row 2 doesn't equal table 2 row 2.

So i want access to tell me where data doesn't match with each other,
just say by putting in an extra field where he puts in a 1 for correct
/ matches. And a 0 for doesn't match / doesn't matches.

Somehow this should be possible but i can't figure it out, so help
would come in handy.

Thanks.

 

[Rob Wilson]

If you just want a quick reference... add a field (say "match" for
example) to each table. Add both tables to an update query. Make
field to field relationships (except for the "match" fields). Update
the "match" field for each table to 1 with no conditions. This will
result in all records that match getting a 1 in the match field and the
ones not matching being left null.

Hope it helps.
Rob Wilson