vpopper
asked on
How do I make two conditions in an Access Query
Not Like "FFF*" Or Not Like "PHARMEDIUM*"
I am trying to exclude two vendors from an access query. If I do a not like for one or each of these, it seems to work but if I combine, it does not. I tried () but not sure I am placing correctly. Can any one suggest a change above that would work for both when running???
I am trying to exclude two vendors from an access query. If I do a not like for one or each of these, it seems to work but if I combine, it does not. I tried () but not sure I am placing correctly. Can any one suggest a change above that would work for both when running???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried that already and did not work I solved by using this:
Not Like "FFF*" and Not Like "PHARMEDIUM*"
Thanks
Not Like "FFF*" and Not Like "PHARMEDIUM*"
Thanks
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for vpopper's comment #a40649826
for the following reason:
Solved this myself
Accepted answer: 0 points for vpopper's comment #a40649826
for the following reason:
Solved this myself
Isn't that what I said? You may have solved it yourself also, but you did get the correct answer from my post.
If you want to combine two negated conditions, then you need to negate a combined condition. So what you want is something like "Not (Like "FFF" or Like "PHARMEDIUM"). Note that the brackets are important here.
/T
/T
ASKER
ie. Pharmedium, Pharmedium LTD, Pharmedium Company