Hello - In an effort to troubleshoot a boolean text search in a database, I made two search queries, one = “smoking pot” and one = NOT “smoking pot” (in both cases I spread the coding to the data cell). I thought that would code every text in my database as one of those two codes. Instead, there were many texts which were not coded at all. Doing a matrix query (see attached) it looks like items were only coded as NOT “smoking pot” if they had “pot” but not “smoking pot”. Why would that be?
Thanks,
-Laura
smoking pot individual vs combined.xlsx