I
iccsi
I have follwing data to create crosstab query and column heading is
Grade.
Student ID GRADE
1 A
2 B
3 A
4 D
5 C
I wanted to create a crosstab and use the query after.
The issue is sometimes the crosstab does not return "C" and "D"
column, since there is no C and D grade.
Can I have a dynamic crosstab query for differnt results?
For example, if there is A and B grade than the result will be
Student ID, Total, A, B. If there is C in the grade returns Student
ID, A, B, C.
Because another query needs run the query, is it possible to have a
dynamic crosstab query?
Your help is great appreciated,
Grade.
Student ID GRADE
1 A
2 B
3 A
4 D
5 C
I wanted to create a crosstab and use the query after.
The issue is sometimes the crosstab does not return "C" and "D"
column, since there is no C and D grade.
Can I have a dynamic crosstab query for differnt results?
For example, if there is A and B grade than the result will be
Student ID, Total, A, B. If there is C in the grade returns Student
ID, A, B, C.
Because another query needs run the query, is it possible to have a
dynamic crosstab query?
Your help is great appreciated,