Uncompleted work.

[Jeanne Conroy]

I have three tables -- students, gradeable work and scores. Students
contains student info; gradeable work contains one record for each
assignment possible. Scores contains the Student ID, Assignment ID, and the
student's actual score. I want to write a query that determines which
assignments students have NOT been graded for (not turned in). Can anyone
help?

 

[Tom Ellison]

Dear Jeanne:

Make a SELECT query using the students and gradeable work table into a
cross product. LEFT JOIN this to the scores table and filter using
WHERE [actual score] IS NULL.

For more detailed help, please try to write as much of this query as
you can and post it along with any missing details and what it is or
is not doing.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Dale Fye]

Jeanne,

Some air code you can use to get started. This will return the student ID
and assignment ID for each combination where the student has not received a
grade.

Select T.Student_ID, T.Assignment_ID
FROM
(SELECT Students.StudentID, Assignments.Assignment_ID
FROM Students, Assignments) as T
LEFT JOIN GradableWork GW
ON T.Student_ID = GW.Student_ID
AND T.Assignment_ID = GW.Assignment_ID
WHERE GW.Student_ID IS NULL

HTH
Dale