Pivot table

J

Jenny

I have two tables below:

table1:
ID Type
a assigment
b test
c research
d final results

table2: stuid type result date
course
stu1 a c 2006-3-1
cs1
stu2 a c 2006-3-1
cs1
stu3 a n 2006-3-1
cs1
stu1 b c 2006-3-6
cs1
stu2 b c 2006-3-6
cs1
stu3 b n 2006-3-6
cs1
stu1 c c 2006-4-1
cs1

I want to show the data in a form like this:

CS1:

student assigment test
research
stu1 c c
c
stu2 c c
c
stu3 n n



how can I do? I want to use pivot table, but I cant remove the grand
total. Or do I need to change the table structure?
Any one can help me?
 
Top