Solved Query Help

[KINGOFCHAOS17]

Yes, not elegant and going to get worse if you need to ignore other categories. That is why as IN() is easier to read.
You could even consider another field that would group what you want at any time, and can be easily amended if that changes a lot.?

How would I do that?

 

[Gasman]

Well instead of individual categories, you would group them into another category, so in this case it would just check for 3 values. Then if for some reason you wanted to ignore one already included, you would put it in another category.
Just depends on how often the criteria changes and it's complexity.