Our organization has 6 assignment levels with training requirements for each level. I've created tables listing levels, listing courses, listing students, and a combo table that holds students, each course they have taken, and the date it was completed.  I want to create a report, based on each student, that has a stagnate location for each of the classes showing the date completed, if done, or if not done, a blank field. These courses do not have to be taken in any order.  The only idea I have come up with is a query with an if/then that would fill the date for each course name then create the report off of that query but if that would work, I can't get the criteria right.

Student Name:   Joe Smith

Level 1
  Course 1     6/5/1995
  Course 2     7/12/1996
  Course 3     7/12/1996

Level 2
  Course 4    
  Course 5    
  Course 6     8/3/2000

Any ideas, folks?