I am overthinking this and need some help.
I'm trying to filter my query to not pull a few different values from one column. When I enter thee criteria Not Like '*25*' the query does not pull through rows that have 25 in this column. How do I tell it to not pull multiple numbers?
This is not working, because I'm thinking this is for the text format - correct?
Not Like ‘*25*’ and Not Like ‘*26*’ and Not Like ‘*54*’ and Not Like ‘*77*’ and Not Like ‘*91*’
Thanks for your help!
AKB
I'm trying to filter my query to not pull a few different values from one column. When I enter thee criteria Not Like '*25*' the query does not pull through rows that have 25 in this column. How do I tell it to not pull multiple numbers?
This is not working, because I'm thinking this is for the text format - correct?
Not Like ‘*25*’ and Not Like ‘*26*’ and Not Like ‘*54*’ and Not Like ‘*77*’ and Not Like ‘*91*’
Thanks for your help!
AKB