<yf******@gmail .comwrote
I have one query with a list of people and
required courses they have to take and another
with the same people and courses they have
already taken. How do I generate a query with
required courses they have NOT
taken? Anybody have any suggestions?
<CHUCKLEAnyon e not here, please answer "absent."
Query 1: people and courses they must take
Fields: person, course required
Query 2: people and courses taken
Fields: person, course taken
1. In the QueryBuilder, create a new Query, with both Query1 and Query2 as
data sources.
2. Drag person and course required from Query1 down to the grid then drag
person and course taken from Query2 down to the grid.
3. Click on person in Query1 and drag to person in Query2.
4. Click on course required in Query1 and drag to course taken in Query2.
In the Criteria line beneath Query2.Person and Query2.Course, enter "Is
Null" (without the quotes, of course).
5. Click on each of the join lines, right click, choose Join Properties, and
examine, you'll find the default is "only include records where the joined
fields from both tables are equal"; instead click on the option just below
"include all records from Query1 and only those from Query2 which are equal"
6. As there will be nothing to show (since by definition, they must be
Null -- not there), you can uncheck Show under Query2.Person and
Query2.Course
7. Run the Query
8. Save the Query for later use
Larry Linson
Microsoft Office Access MVP