Trouble with queries, please help

G

guy12345

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.
 
J

Jerry Whittle

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.
 
G

guy12345

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.
 
G

guy12345

John and Jerry,
Thanks a lot . I got it to work. I really appricate your help.
 
Top