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???
Microsoft Access
Last Comment
Tony Pitt
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
ie. Pharmedium, Pharmedium LTD, Pharmedium Company