I have one more question. How do I join two crosstab queries so that I have 2 column rows.
So for example, I want all people name in row heading of crosstab query and courses they need to learn in column heading and another column heading which is type of course.
Course A Course B Course C
Type A Type B Type C
Joe
John
Jessica
I have to also set the criteria as "dept" person belong to.