Null values in Report

[balajigade]

I am working on a database of students' marks with fields like 'id', 'subject','marks', 'credits' etc. by copying the results published in excel format to the access 'results' table and generate various reports like aggregates, total credits etc. If the student is absent for a subject, the published results do not show any record against this id for the particular subject. In that case when others have, say, 10 subjects, he will have only 9 subjects in my report.Instead, I would like to show null or zero value against the particular subject of the student in the report. Someone suggested me to use the IN("") function in the query for each subject name, but in such case I will have to deal with hundreds of subjects !! How do I address this?

[June7]

Need a dataset that pairs each student with every possible subject. This can be generated with a query that includes Students table and Subjects table. There will not be a JOIN clause in the query and this will result in a Cartesian relationship - every record of each table will associate with every record of other table.

Then join that query to the Results table with a join type of "Include all records from the {Cartesian query name} and only those records from Results that match". The join will be a compound link on student ID and subject ID.

[balajigade]

Thanks. Problem solved