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?