Because that would result in A00001 showing up as both Active and Inactive. This a pass-through query running on SQL, but works fine in Access.
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
Why are you using NOT IN? First off, Access optimizes that very badly. But it should have worked.
This should do it:
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
On Apr 26, 2016, at 6:14 PM, runuphillracing@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (4)|