omitting in a query

[agorman]

Hi,

I have a list of people in 18 countries and I want to run a query to list people from countries other than Slovenia and Croatia

I have been able to get the querry to work with 'not Slovenia' but cannot get it to omit slovenia and croatia
'Not Slovenia or Croatia' does not work

Can someone point me in the right direction

Thanks

Adrian

 

[Huck]

Have you tried:- Not like "Slovenia" and not like "Croatia"?
That should work

 

[agorman]

Works great, much appriciated.

Adrian

 

[MSAccessRookie]

Hi,

I have a list of people in 18 countries and I want to run a query to list people from countries other than Slovenia and Croatia

I have been able to get the querry to work with 'not Slovenia' but cannot get it to omit slovenia and croatia
'Not Slovenia or Croatia' does not work

Can someone point me in the right direction

Thanks

Adrian

Try the IN qualifier for Sets.

Not In ("Slovenia", "Croatia")

Note: I noticed the LIKE option provided by Huck. Thatr will do sort of the same thing. The only thing that I can see wrong with it is that if there were an entry that contained either word along with other letters, it would be included because of how LIKE works. In this case, it would probably not be an issue, so this observation should be considered for future reference.

 

[Huck]

You're welcome