Show placeholder for missing records/values (1 Viewer)

[N1029676]

My database imports CSV files containing 'answers' to test questions. I have a query to calculate the error in the analysts answer. My problem is each test has 12 questions and should have 12 responses from everyone, but it is possible that analysts may only provide 8 responses. Right now the query just evaluates what is available and does not calculate missing answers as errors.

How can I have the missing records populate anyway?

Table structure:

Answers        Responses      Analyst
  AID            RID            UID
  MissionID ---- MissionID      
  PointID ------ PointID        
  Answer         Answer
                 Analyst ------ Analyst

Sorry for the crude representation of the tables I'm on a tablet right now. Might be able to update the post with a better image of setup later tonight.

Any ideas?

Thanks
-Tim