Find values on all lines

[cring]

I have an internal control number that can have multiple lines for each.  I am trying to find those internal control numbers where ALL lines equal the same  value.  Any help is appreciated!

Example:

Internal Control Number         Line #       Value
11111111111111                        1             xyz
11111111111111                        2             xyz

[BigChris]

You might be able to do this with a filter, something along the lines of:

count([Line #] for [Internal Control Number],[Value]) = count([Line #] for [Internal Control Number])

Have an experiment and see what that throws up...