Help using "Not" in a query (1 Viewer)

[kurting0]

I have a table which has concatenated values that are seperated with slashes. For instance INA/DOC/POR/NMN/NOC
When I write a query and want to return all results that do not contain INA or NOC I am using in the criteria area:
Not Like "*NOC*" OR not Like "*INA*"

The results still include those values when I run the query. What other ways are there to exclude values from within a string like the one I mentioned. Thanks for your help.

 

[SMatthews]

Change the OR to AND.

 

[kurting0]

Thanks. You are correct, maybe I just stared at it too long.

 

[Pat Hartman]

While you're at it you might consider getting rid of the string and storing the data properly in a separate table with a row per entry. The proper structure will be far easier to work with in the long run.