Please see attached example.
I want a list of all the award numbers in table 1 that do not have a match in table 2. But I want Access to only search awards in table 2 that have calendar year 2009, calendar quarter 3, and last update 10/1/2009. In this example, the list would include award numbers: xoexf, eisld, and clien.
I want a query where I can simply change the year, quarter, and last update and get a new list, based on those parameters. Is this possible or do I have to separate table 2 into a table for each date within the last update field and do separate queries?