How do I compare 2 list {or queries} with each other.

R

Rick Richmond

I retrieve a list of students that have completed training and want to
compare this list with the students that missed the class.
I have played with "Unmatched Query" but still don't get it.
 
K

KARL DEWEY

When you say 'compare' you did not say what you expected to see in the
results --
- List1 not in List2
- List1 same as List2
- List2 not in List1

Maybe you need to be using Student Body list in your comparison to find how
many in the Student Body list attended but did not completed.
 
J

Jason Oliver

I too am trying to figure out how to do this. I want to create a report that
compares all employees to all employees that have completed training and
displays all employees that have not completed the training. So basically,

List1 (all employees) not in List2 (employees trained)
 
Top