How to use "like" and "not like" in SQL MSAccess for the same field?

Question

I would like to filter all the rows that are: ``` field like "*AA*" and field not like "*BB*" ``` But this is returning everything instead of showing all the rows that contains `AA` and doesn't contain `BB`. well now it works like expected, just restarted ms access... Sorry for my typo... :s updated

Accepted Answer

Try this:

```
field like "*AA*" and field not like "*BB*"
```

How to use "like" and "not like" in SQL MSAccess for the same field?

Solution

Problem