Query - Search for this, not this + that...

[ash432012]

Hello all,



I hope I can take whatever advice is given to me and execute it!
I feel like I know a lot about Access as far as how it pertains to what we do here [at work]
but I don't think I'm very well versed in it overall...

Anyway, here's my question...
[btw - I don't know how to run queries using SQL -- I can alter them/take them apart, but not create from scratch...YET! lol..]

Okay, so ..in the Query design view... I have a table w/a bunch of parts listed... those parts are being edited/paired to dwgs by our 10+ employees --
I have instructed them that if there is ever anything they are unsure about, to put a comment in a notes field that says "Review"
As I've been doing QC throughout the project, I've corrected some of these, and others I have added my boss's name so that we can run a query for his name and quickly see what I need him to review...

Now that we're pretty far into the project, I need to run a query for all the parts that have "Review" in the notes section, but NOT the one's that include my boss's name + review --
is there anyway to run this query?
I've tried
Like "*review*" And <>"*cox*"
in the criteria row, but the entries w/his name are still coming up..
This would be a really helpful skill to learn for a lot of other things that I need to QC in our database
Any assistance you could offer would be greatly appreciated!
Let me know if there is anything else you need to know to help me with this!

Thanks guys!
Ash

[alansidman]

Would you upload a copy of the db with some sample data. Make sure that all confidential data has been scrubbed (modified) so that no confidential info is disclosed. Run a compact and repair before you upload.

[ssanfu]

Like "*review*" And <>"*cox*"

Did you try

Like "*review*" And Not Like "*cox*"

You could try using two queries.
-- WARNING: this is off the top of my head - not tested ---
Create the first query and in the criteria row for the comments use
]code]Like "*review*"[/code]
Save it with a name like "qryLikeReview"
Now create a 2nd query and use the first query "qryLikeReview"
Add the fields, then in the qriteria row for the comments field, use

Not Like "*cox*"

The first query gathers all records what has "review" in the comments field and the 2nd query looks for any record that does not have cox in the comments field.