Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Evaluate all Group 2's within Group 1

Status
Not open for further replies.

jenschmidt

Programmer
Sep 30, 2002
145
US
Greetings!

I need to suppress records based on the group 2's that are rolled up into a Group 1. Here's an example of the layers:

GH#1 93379
GH#2 26
GH#2 TC

GH#1 93380
GH#2
GH#2 TC

GH#1 93381
GH#2
GH#2 26
GH#2 TC

There are many varying combinations, but I only want to see the data if under Group 1 there is a null group2 AND a 26 group2 AND a TC group2. In the above example, I really only want to see the last Group 1. What do I write in the supression or selection criteria to get the correct result?

Thanks everyone!
Jen jennifer.giemza@uwmf.wisc.edu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top