Remove rows that has a sum of 0

[Minty]

We all get that - that is not what I or plog are asking you. I'll try once more

Take this data

ID -Code - Value
1 - AAA, -10
2 - AAA, -20
3 - AAA, -40
4 - AAA, 10
5 - AAA, 20
6 - AAA, 30
7 - AAA, 40
8 - AAA, 50
9 - AAA, 60
10 - AAA, 70

Now based on your current requirement I could show you at least the following as things that don't match your requirements , In other words these columns are what would be left over that don't add up to the negative values;

	        5 - AAA, 20	4 - AAA, 10	4 - AAA, 10
5 - AAA, 20	6 - AAA, 30	6 - AAA, 30	5 - AAA, 20
8 - AAA, 50	7 - AAA, 40	7 - AAA, 40	8 - AAA, 50
9 - AAA, 60	8 - AAA, 50	9 - AAA, 60	9 - AAA, 60
10 - AAA, 70	10 - AAA, 70	10 - AAA, 70	10 - AAA, 70

So as Access cannot guess which outcome is correct, you have to make a logical statement that would restrict your query to only give you one result set based on something else in the data.