CrossTab Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Not sure how to do this but I have a traning database and I would like to get
a table that is Employee Level vs Class Name. Where a class is mandatory
would be a true condition. I have a list of levels in one table, and in
another table two columns (level and class number)

Table 1 - Levels
Grade 1
Grade 2
Grade 3

Table 2 - Class Assignments
Level Class
Grade 1 1
Grade 1 2
Grade 2 2
Grade 2 4
Grade 3 3
Grade 3 5

Desired Result
Grade 1 Grade 2 Grade 3
Class 1 X
Class 2 X X
Class 3 X
Class 4 X
Class 5 X

Thanks
 
TRANSFORM iif(0=Nz(COUNT(*), 0) , " ", "X") as TheCell
SELECT "Class" & Class
FROM table2
GROUP BY "Class" & Class
PIVOT level



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top