By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 2,377 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

HELP! unmatched records query...

P: n/a
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?
Aug 1 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a

<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?
<CHUCKLEAnyone 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


Aug 1 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.