Good morning all,
Any help with this would be greatly appreciated (I’m sure this will be a total no-brainer for some of you).
I have two tables, my primary key is ACT ID, in table 1 I have another field called Earned, this field is also in table 2,, basically the value of Earned field in table 2 is different from that in table one,,, is there a simple query I can write to find these differences,, I have approx 200 values in both tables and approx 25 of the Earned values have changed.
Many thanks
Any help with this would be greatly appreciated (I’m sure this will be a total no-brainer for some of you).
I have two tables, my primary key is ACT ID, in table 1 I have another field called Earned, this field is also in table 2,, basically the value of Earned field in table 2 is different from that in table one,,, is there a simple query I can write to find these differences,, I have approx 200 values in both tables and approx 25 of the Earned values have changed.
Many thanks