Hello
I have done a crosstab query and I get the results I was looking for. However, there is a column which shows up in the query and I am unsure why. It is the column with <>., highlighted in yellow. I can't seem to delete the column and when I print to Excel this column is present, which I don't want. I have tried hiding the column but it still is displayed in Excel. The SQL generated is below:
TRANSFORM Last(qCoursesAttendedReport.[Course Check]) AS [LastOfCourse Check]
SELECT qCoursesAttendedReport.LastName
FROM qCoursesAttendedReport
GROUP BY qCoursesAttendedReport.LastName
PIVOT qCoursesAttendedReport.EventName;