Wrong values in query result

[Vanita]

Helloo there..

1. I have two tables a.Production plan and b.Production monitoring.
2. A perticular item is planned for production in table 'a' and the same is monitored in table 'b'(Monitoring: Against planned how many are produced and how many are rejected etc).


3. In a query am trying to get the difference of 'Planned Qty' and 'Produced Qty", since the resulted diff qty needs to be planned again in table 'a' untill the difference value is =0.
4. Have designed a query (screen shot attached for reference), no idea for what reason the values are very much wrong.
5. Please help!

will share if any other details are required for clarification.

[Vanita]

Please ignore the 2nd attachment named 'image' attached by mistake.

[JoeM]

First off, NEVER create calculated fields that use an Alias (name) that is exactly the same as the field names! That can cause all sorts of ambiguity and unexpected results.
Secondaly, I don't know if you can do the SUMs and the difference of the SUMs in the same query.

So, first try giving your calculated fields new names, and then update the formula that checks the difference between them.
If that does still not work, try breaking it up into two queries, and see if that works.
So, your first query would have the two calculated fields that do the SUM.
Then the second query would use the first query as its source, and you can subtract the two calculated fields there.