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