Unmatched Query Comparing Two queries for missing records

[Guest]

I must be missing something, because I'm trying to get Access 2000 to compare
to sets of records and tell me if any rows from one set do not appear in
another.
Let me expand, I've written a fairly simple (I'm not a programmer) database
that we use to track employee training. We have some training that is
required, by virue of someone's position. By joining tables and linking, I
can produce easily a list of 'who's taken what" and "who should have taken
what'? What I cant do is quickly find out "who's not taken what they should
have?"
When I try and use the "Unmatched query" it asks 'what field is the same in
each query - the fact is all the fields are the same I have only 5 fields
"Employee ID, FirstName, LastName, ModuleName and Position. It doesn't matter
which field I chose as "the joining" field, I get inaccurate and incomplete
results. Is there a simple way to do this, I feel that it should be very
simple to just scroll down one list and note that that exact record is
missing from another list, but I'm obviously doing something wrong.

Any help would be appreciated
Regards
Mel Morris

 

[John Vinson]

I must be missing something, because I'm trying to get Access 2000 to compare
to sets of records and tell me if any rows from one set do not appear in
another.
Let me expand, I've written a fairly simple (I'm not a programmer) database
that we use to track employee training. We have some training that is
required, by virue of someone's position. By joining tables and linking, I
can produce easily a list of 'who's taken what" and "who should have taken
what'? What I cant do is quickly find out "who's not taken what they should
have?"
When I try and use the "Unmatched query" it asks 'what field is the same in
each query - the fact is all the fields are the same I have only 5 fields
"Employee ID, FirstName, LastName, ModuleName and Position. It doesn't matter
which field I chose as "the joining" field, I get inaccurate and incomplete
results. Is there a simple way to do this, I feel that it should be very
simple to just scroll down one list and note that that exact record is
missing from another list, but I'm obviously doing something wrong.

Do you have just the *one* flat table here? If so, how do you handle
the case where an employee has taken several Modules? Do you enter
their name repeatedly?

If so, you're not taking advantage of the power of Access as a
relational database. Please post back explaining how you have your
data stored. You may be OK but I fear you're not... but we can get it
fixed up for you!

John W. Vinson[MVP]

 

[Guest]

No, it's not flat. I have
a number of main tables each linked with junction tables.
One has employee information
One is a list of positions and related info
One is a list of Training Modules Names
One is a table i call training schedules which relates to every specific
time any training is offered (an employee does not just take multiple
modules, they may well take the same module on multiple ocassions over
several years)
These are joined with junction tables.
The two subsets of data I'm comparing are constructed via queries to
generate the info I've given - I have constructed a Form and sub form which
shows the info I want ie. the employee, what training they've taken, what
training they need, but because it's in a cumbersome format I wanted an easy
way to Say okay, "Avoiding Back Injuries" - who hasn't taken it - who needs
to have taken it (it's determined via the position held) I can tell from a
simple query who hasn't taken a Module, or even a specific Module ID (a
subject on a given date) but that query just tells me everyone who hasn't
taken it - including everyone who doesn;t need it - I'm probably rambling
but if you need more info please ask again.
I appreciate your help in this
regards
mel Morris

 

[Guest]

John, could you please get back to me, I hope that you will be able to help
me - see my last response to your question.
Thanks
Mel Morris