Finding matching records

[johnsaw]

I posted a message earlier, but didn't really explain it properly so i will try again.
I have two queries which i created from a table called submission they being SubAssign and UnSubAssign.

Each Query contains the same fields.

StudentID,AssignCode,Surname,AssignNumber, AssignTitle.

As each student can have submitted more than one assignment and the AssignCode could be the same for maybe Thirty students, the only way to uniquely identify a record is from both these fields. What I want to do is produce another query which gives me all the records that are not the same in each table. Using the unmatched query, which works on one field is no good as I either loose all records by students with the same studentID or using AssignCode, i loose all records with the same AssignCode, I just want to lose the records where the StudentID 'AND' the AssignCode are the same in each. Cheers for any help on this. Because i am completely stuck

 

[John@backacre.co.uk]

I'm not an expert but saw your question whilst searching for a solution to my problem!
If you have used the query wizard to find unmatched, it uses only one matching field. However if you open the design view of that query, you can create other joins that then produces a result matching all of the joined fields.