Find Missing Record

[balajigade]

I am maintaining a database of students and their results. The fields in the 'results' table are student_ID, subject_code & credits. There are 10 subjects and the credits are tabulated student_ID-wise, i.e. the student_ID changes after every 10 records. Simple. After updating the table by copy-pasting from an excel file containing latest results, it was noticed that some results are missing--a few student_IDs had only 8 or 9 subject_codes against their entries. There are no null values at all. Now how to set a query to find out what are the student_IDs and the sub_codes for which credits are not available?

[ranman256]

You want an OUTER JOIN. Take the tSubect table join it to tResults table on subjectID. Dbl-click the 'join line' between tables it will ask what type of join?

You want ALL records in tSubject but not in tResults. Bring down [subject] field from both tables (and any others)
Run the query and the missing records will show as blank.

[dmon2010]

Is there a way to do this based on 3 columns? I'm working on a comic book database and I can pull up my missing numbers, but only based on title and issue. I'd like to be able to base it on title, issue and version.

Title and issue are self explanatory, version is "A", "B", "C", etc depending on cover version or if its a reprint.

[orange]

What is the PK of your table?
What query(ies) have you tried? With what results?

[balajigade]

Thanks for quick response. I've tried exactly the above but I what I see is the sub_code field fully populated and all other fields shown as blank for records where the results are missing. What I want is to see is the studentID with the sub_code which has a blank value