MultiSelect and advanced query

E

Edro

I had a bad feeling that might happen. Ok here we go

I have a table with FIELD1 and FIELD2.
FIELD1 is a list of applications and FIELD2 is usernames
The goal is to show usernames from the multiselected list
where there is only a match. In other words if a user has only one
of the multiselected apps then no data returned. Likewise if username
has any other application not in the multiselected then no dat
returned.

E.g

Table------
FIELD1 FIELD2
Access97 John Doe
Access97 Billy Bob
MSWORD John Doe
MSWORD Billy Bob
MSEXCEL John Doe
MSEXCEL Jane Doe

Multiselected Access97 and MSWORD
Output - Billy Bob


Thanks in advance,

E
 
Top