Differences in Values

wardy

Registered User.
Local time
Today, 15:54
Joined
Sep 4, 2007
Messages
21
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
 
Place the 2 tables in a query and create the relationship using a common field (if it doesn't do it for you), then add the fields from both tables you need, then save the query.

Next add an expression which will take the value from the first field and subtract from the next field.

Expr1: ([FieldName1]-[FieldName2])
 
Many thanks Tevor
 

Users who are viewing this thread

Back
Top Bottom