Access query compare does not work using Not in or not equal
Posted on 2014-04-14
In an Access db I have forms based on queries. One of the queries is supposed to return data but not data that was in the other query. I join the queries and tried Not In, <> and Is Null but do not get the expected results. I am wondering if having one of my fields named "Value" is an issue because it is a reserved word? Because of that I have the initial query run and build a table that contains only only one field with unique results. The next query should return results that are valid but exclusive of those returned in the first query. How do I get results that are unique among the two queries?