Trouble with queries, please help

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

Guest

Im trying to perform a query that will return all the values in a field
except two. eg. I have 1, 2, 3, 4, 5, and 6 as values in the field and would
be trying to return all the values except 2 and 4 to get all records with
values of 1,3,5 and 6. However, in my real database there are many different
types of values and they are words. I have tried using the not operator as
well as the <> operator. please help if you can. I appricate it. thanks.
 
You failed to mention what it is not doing. Also provide a sample of the sql
statement so that we can see what you tried.
 
Jerry,
It still returns records with values of 2 and 4. the "not like" operator
seems to work however only when i do it for one of the values.
 
Back
Top