Query Help

Question: I have a master data that looks like..

P C
------
p1 c1
p2 c2
p3 c3
p4 c4
p5 c2
p6 c1

How can i find the P's that has the same C's. That is my result in the report should be

p1 c1
p2 c2
p5 c2
p6 c1

Thanks..

Answer:
Can any one help me on this...

Answer:
Change the order of your drilldowns to make C first followed by P. That way all of the values of C will be grouped together first, followed by the values of P.

Hope this helps...

Bob
Copyright ?2007 - 2008 www.jt77.com