Restricting responses in queries

[Guest]

To query a field that has a value list in order to restrict the response to
certain values from the list I use this method:

In ("Value1","Value2",) etc

How would it work if I wanted to restrict mutiple values. Ie if there were
a lot more values that I didnt want then I did. For one value I use NOT but
this only seems to work for one.

Just wondering how this is done because at the moment I type out all the
ones I do want which is alot more then the ones I dont.

Ian

 

[Nikos Yannacopoulos]

To query a field that has a value list in order to restrict the response to
certain values from the list I use this method:

In ("Value1","Value2",) etc

How would it work if I wanted to restrict mutiple values. Ie if there were
a lot more values that I didnt want then I did. For one value I use NOT but
this only seems to work for one.

Wrong. Not In (value1, value2, ...., valueX) works just fine!

HTH,
Nikos