Morning! I have a pretty simple data set.
One table is a list of student names - meaning every student is in this list.
The other table is a list of historical classes that students have taken. This means that only the student that have taken a class show in this list.
What I am trying to figure out is this - for each class which of the 5 students have and have not taken each class?
Because both tables do not have a course listing, I am not able to join on some sort of course ID. So I am not sure what is the best approach to solving this issue - join or a calc?
Thanks,
Scott
@Michael Hesser
scott
I have to send this in a number of responses - can only attach one at a time
I used this file - add a course list so I could join them in prep