Compare sum of values in rows with same ID to another value

[dclark28]

Hi All,

I am not sure if this would be a better project for Excel or Access but here is what I am trying to do and I apologize if I am not explaining this well as it is a bit hard to explain.

I need to compare the sum of a values in a column of rows with the same id. For example:

ID          Value1   Value2

122222   20        40      (these are okay, the sum of Value1 in rows with same ID equal value 2)
122222   20        40
333333   100        100      (ok)
111111   50          100      
111111   50          100      (not ok, the values with same id add to 150, so the first row containing this id should be deleted so the the total of Value1 equals Value2)
111111   50          100

Thanks for any help!

[Robeen]

You might consider creating a Query - and then doing a Group By on ID, Sum on Value1 and Average of Value2?
This would work with the data you're showing [where all values under Value1 for the same ID are identical - AND all values under Value2 for the same ID are identical].

This would give you the two values you want to compare.

BUT . . . if you want to delete rows [you said "so the first row containing this id should be deleted . . ."] - then that's a different ball game.

It's not totally clear what you need your end result to be. Could you perhaps explain a little more?