Re: Exclusion list in a query-by-example ✓ Answered: green (solid confidence) — The original poster (quoting their own full original question about a query-by-example exclusion list) returns to report they received a definitive 'no' from a responder by private email and thanks them, which is exactly the person-who-asked confirmation the design calls for.

Advisory only.

Jacob Salomon (that's me) wrote: --SNIP-- >OK, so much for the preliminaries. Now I want query on all states NOT >in that list. i.e. the constructed WHERE clause of the query would be: >WHERE state NOT in ("NY", "NJ", "MN"). I believe what I am looking for >is called an EXCLUSION LIST > >Is there any way for a user to enter exclusion list/pattern on the >query form? >--SNIP-- > Thanks for any ideas. Even thanks for definite NO. Thanks to XXXXX@YYYYYYYY.ZZZ who supplied me with the definitive *no*. I have blanked out the person'n e-mail addr - If he had wanted it posted, he would have done so. -- -- Jake (Knows when to stop seeking the probably impossible) . . _..-'( )`-.._ ./'. '||\\\\. }\\_/{ .//||` .`\\. ./'.|'.'||||\\\\|.. )o o( ..|//||||`.`|.`\\. ./'..|'.|| |||||\\`````` \\'@'/ ''''''/||||| ||.`|..`\\. ./'.||'.|||| ||||||||||||. | .|||||||||||| ||||.`||.`\\. /'|||'.|||||| ||||||||||||{ | }|||||||||||| ||||||.`|||`\\ '.|||'.||||||| ||||||||||||{ | }|||||||||||| |||||||.`|||.` '.||| ||||||||| |/' ``\\||`` | ''||/'' `\\| ||||||||| |||.` |/' \\./' `\\./ \\!|\\ /|!/ \\./' `\\./ `\\| V V V }' `\\ /' `{ V V V \\ \\ \\ V / / / +-----------------------------------------------------------+ | Impeccable Logic: A thought process which successfully | | resists chicken bites | +-----------------------------------------------------------+