can you make crosstab query with more than one pivot column?

H

Howard

A simplified version of a table I have contains the following fields related
to the potential and actual grades recorded in an educational management
system

StudentID, SubjectID, PotentialMark, ActualMark

I want to do a cross tab so that I get the studentID as rows but instead of
a single column for every SubjectID with a mark in the matrix, I want to
have pairs of columns showing the potentail and actul mark for each subject
ID found.

Is this possible without doing two crosstabs and somhow combining them
(tricky as I may not know what subjectID columns the crosstab will return)

(I know the table is not normalised but thats what I have to work with from
the export I get from the MIS)

Howard
 
D

Duane Hookom

You can do this with a single crosstab using the solution found at
http://www.tek-tips.com/faqs.cfm?fid=4524.

In your case, you would need to create a table with two records and values
like "Potential" and "Actual". It really doesn't make much difference what
you store in the records as long as there are two and they are unique.
 
H

Howard

Thank you Duane,
Your knowledge - and response time- never cease to amaze me!
Howard
 
H

Howard

Thank You Duane
Your knowledge - and response time- never cease to amaze me
Howard
 
Top