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

User · Answer

what s the problem with   field like   AA   and field not like   BB     it should be working   Could you post some example of your data

User · Answer

What I found out is that MS Access will reject --Not Like  BB  -- if not enclosed in PARENTHESES  unlike --Like  BB  -- which is ok without parentheses   I tested these on MS Access 2010 and are all valid    Like  BB   Like  BB    Not Like  BB

User · Answer

Not sure if this is still extant but I m guessing you need something like    field Like  AA    AND  field Not Like  BB

User · Answer

Try this   filed like   AA   and filed not like   BB

User · Answer

If you re doing it in VBA  and not in a query  then     where field like  AA  and field not like  BB  then would not work     You d have to use     where field like  AA  and field like  BB    false then

User · Answer

Simply restate the target field  amp  condition   where  field like   AA   and field not like   BB

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

Examples related to sql

Examples related to ms-access

Examples related to where

Examples related to sql-like