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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top