Restricting responses in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...
Wrong. Not In (value1, value2, ...., valueX) works just fine!

HTH,
Nikos
 
Back
Top