AnsweredAssumed Answered

I'm sure its trivial, but...

Question asked by JohnBrookes on Apr 18, 2012
Latest reply on Apr 18, 2012 by JohnBrookes

Title

I'm sure its trivial, but...

Post

OK, I have a table with fields:

IDStudent_NumberSubjectGrade

Each student will have grades in several subjects.  I want to look at performance in one subject against another for the whole class.  So for example I want to find all students who have done physics and economics, and I want my output to be:

Student Number Subject1 Grade 1 Subject2 Grade2.

1234Physics74Economics55

2345Phyiscs72Economics88

3456Physics98Economics 72

So I've got a solution that sort of works.  I make a copy of the file, and then make a layout based on the original file with the fields Student_Number SubjectGrade from the original file and fields  Subject2Grade2 from the copy.  Then I do a find on Subject and Subject2, and sure enough I get all the students doing Subject and Subject2.  But the subject that is actually displayed in Subject2 is not the one I searched on in that field.  It is simply the first subject entry for that student.

Ultimately, I just want the output to be an excel file with Grade1 and Grade2 columns.

Any help would be greatly appreciated.

Outcomes