Experts Exchange connects you with the people and services you need so you can get back to work.

Microsoft Access Query Not working

I have a customer table with a text field called "Country"

When I run a query with the criteria of Country = "Canada" I get the correct results.

When I run the query with the criteria of Country <> "Canada" I don't get any records.

I have never seen this before. I initially had tried to do this in VBA but when that didn't work I created a query and it's still not working.

Weird. Any ideas?

Eileen Murphy

Asked: 2014-01-24

Advertise Here

1 Solution

LVL 120

Rey Obrero (Capricorn1)Commented: 2014-01-24

have you tried doing a Compact and Repair ?

what if you use another country name, are getting results?

try using this as the criteria

not in("Canada")

LVL 40

Jacques Bourgeois (James Burger)PresidentCommented: 2014-01-24

If the country that are not in Canada are Null, they won't be found. By default, Null values are disregarded by queries because they are indeterminate. That is one reason that many database designers will prefer a default value (something as "(unknown)" instead of a Null to represent unknow data.

If this is the case, then the following should work:

<> "Canada" Or Is Null

Eileen MurphyIndependent Application DeveloperAuthor Commented: 2014-01-24

Compact and Repair of the back-end did the trick. How weird is that? Thanks a bunch!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Microsoft Access Query Not working

Join & Write a Comment Already a member? Login.

Featured Post