J
Jeffrey Marks
This is an existing query to cross tab grades for a particular
student:
TRANSFORM First([08-09 EHS Course Grade].[Final Mark]) AS [LastOfFinal
Mark]
SELECT [09-10 EHS GPA-Absence].[Pupil Number]
FROM ([09-10 EHS GPA-Absence] INNER JOIN [08-09 EHS Course Grade] ON
[09-10 EHS GPA-Absence].[Pupil Number]=[08-09 EHS Course Grade].[Pupil
Number]) INNER JOIN [Course Codes] ON [08-09 EHS Course Grade].[Course
Code]=[Course Codes].[Course Code]
GROUP BY [09-10 EHS GPA-Absence].[Pupil Number]
PIVOT [Course Codes].[Course Name] In
("Math","English","Science","Social Studies");
My problem is that when a student does not have all 4 classes (math,
english, science, social studies) no record appears in the cross tab.
So if student 111111 takes math, english, science and PE, I will not
get a record in the query. I would still like to see a record, just
with nothing in the social studies field. Is that possible?
thanks
jeff
student:
TRANSFORM First([08-09 EHS Course Grade].[Final Mark]) AS [LastOfFinal
Mark]
SELECT [09-10 EHS GPA-Absence].[Pupil Number]
FROM ([09-10 EHS GPA-Absence] INNER JOIN [08-09 EHS Course Grade] ON
[09-10 EHS GPA-Absence].[Pupil Number]=[08-09 EHS Course Grade].[Pupil
Number]) INNER JOIN [Course Codes] ON [08-09 EHS Course Grade].[Course
Code]=[Course Codes].[Course Code]
GROUP BY [09-10 EHS GPA-Absence].[Pupil Number]
PIVOT [Course Codes].[Course Name] In
("Math","English","Science","Social Studies");
My problem is that when a student does not have all 4 classes (math,
english, science, social studies) no record appears in the cross tab.
So if student 111111 takes math, english, science and PE, I will not
get a record in the query. I would still like to see a record, just
with nothing in the social studies field. Is that possible?
thanks
jeff