MultiSelect Help

[Edro]

I think I have pulled as much hair out as I can on this! So here i
goes...

My goal is to query a table containg two fields of redundant data wher
I multiselect from one field and validate that field two data exists i
all multiselected data and field two data not in non-selecte
multiselected data?

Whew Just reading this gives me a headache..

Thanks in advance for any assistance with this


Edr

 

[Angry Pat]

No ones replied cause no one understands what you trying
to say. Give an example of scenarios, using table names,
field names etc...

What do you mean by redundant data.

THIS PART LOSES ME - are you using "two" when you
mean "to".

"... that field two data exists in
all multiselected data and field two data not in non-
selected"

Also use sentences.

-----Original Message-----

I think I have pulled as much hair out as I can on this! So here it
goes...

My goal is to query a table containg two fields of redundant data where
I multiselect from one field and validate that field two data exists in
all multiselected data and field two data not in non- selected
multiselected data?

Whew Just reading this gives me a headache..

Thanks in advance for any assistance with this


Edro


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

.

 

[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