Need Select formula for selecting records from two different columns?

[kre1973]

I have the following two columns of data:

Assignment History Resolve Group
{"NSD, Q-3557, WAN SUPPORT", "FIELD NETWORK"} FIELD NETWORK
{"ACTUARIAL VALUATION SYSTEMS", "COMPUTER OPERATIONS"} COMPUTER OPERATIONS
{"MQ", "COMPUTER OPERATIONS", "MQ", "HO CASE MGMT SUPPORT"} COMPUTER OPERATIONS
{"Q-6996 ESA, PASSWORD SUPPORT", "Q-5576, THE SERVICE CENTER"} Q-5576, THE SERVICE CENTER
{"Q-6996 ESA, PASSWORD SUPPORT"} Q-6996 ESA, PASSWORD SUPPORT
{"COMPUTER OPERATIONS"} COMPUTER OPERATIONS
{"WINDOWS SRVR TEAM INTERNAL SUP", "COMPUTER OPERATIONS", "EMAT"} EMAT
{"ACTUARIAL EXPERIENCE STUDIES", "COMPUTER OPERATIONS"} COMPUTER OPERATIONS
{"NSD, Q-4354, FIELD PC SUPPORT", "AGENCY BUSINESS SYSTEMS"} AGENCY BUSINESS SYSTEMS
{"ACTUARIAL EXPERIENCE STUDIES", "COMPUTER OPERATIONS"} COMPUTER OPERATIONS
{"COMPUTER OPERATIONS"} COMPUTER OPERATIONS

I want to select only records that have the substring "COMPUTER OPERATIONS" in the Assignment History table and "COMPUTER OPERATIONS" in the Resolve Group table.

I hope I explained it correctly.

thanks

 

[lbass]

You could do this with a subreport. Please see
thread766-1458721.

-LB