one query for two tables

[Hmmm]

This seems so simple yet I can't figure it out! please help.

I have 2 tables:

Assignment table (all assignments for a class)
assignid
assignname
classid

Submission table (assignments turned in by student)
assignid
submitid
studentid
classid
submited (yes/no)


i just want a report listing all assignments for a student in a class and
whether each assignment was submitted.

why is this so hard?

 

[Guest]

Create a query joining the two tables by assignID, and base your report on
the query.

Rosco

 

[Guest]

you just need to put both table in the query and right
join them (not inner join them)
Join them on assignid and classid.
once the joins are made right click the join lines and
select join properties. pick from 3 options. you want all
records in the assingment table and matching records in
the submission table.