Jacques Bourgeois (James Burger)PresidentCommented:
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:
what if you use another country name, are getting results?
try using this as the criteria
not in("Canada")