Solution: Building Another Crosstab Query

Step1. Add tblCourses, tblEnrollments, and tblSections to a new query.

Step2. Change the query type to a Crosstab.

Step3. Add the CourseTitle, and SectionNumber fields to the query

Step4. Set the Crosstab row to Row Heading for CourseTitle and SectionNumber fields.

Step5. To add the SemesterYear field to the query.

Step6. Set the Crosstab row to Column Heading for the SemesterYear field

Step7. Add the EnrollID field to the query design grid.

Step8. Set the Crosstab row to Value for EnrollID.

Step9. Set the Total row for the EnrollID field to Count.

Step10. Add a EnrollID to the query design a second time.

Step11. Set the Crosstab row to Row Heading for the second EnrollID field.

Step12. Set the Total Field to Count for the second EnrollID field.

Step13. Set the caption for the second EnrollID field to Total Enrollments.

Step14. View the query.

Step15. Save the query and close it.