This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button
Solved
Microsoft Access Query Not working
Posted on 2014-01-24
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?
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
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")
what if you use another country name, are getting results?
try using this as the criteria
not in("Canada")
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
If this is the case, then the following should work:
<> "Canada" Or Is Null
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses
Course of the Month5 days, left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.