report recordsource from crosstab which columns varies

[Song]

I want to use crosstab as recordsource of report. For field Typ, there are 3
posibilities: Continue, New, Transfer

For some semester, there are only Continue and no New and Transfer record so
my report crash. How to display Continue, New, Transfer column heading
regardless of having record or not?

TRANSFORM Count(tblMaster.SID) AS SIDOfCount
SELECT tblCountry.Country, Count(tblMaster.SID) AS Total
FROM tblEnrolled INNER JOIN (tblCountry RIGHT JOIN tblMaster ON
tblCountry.CountryID = tblMaster.CountryID) ON tblEnrolled.SID =
tblMaster.SID
WHERE (((tblMaster.Active)=Yes) AND ((tblEnrolled.Sem)="3"))
GROUP BY tblCountry.Country, tblMaster.Active
PIVOT tblMaster.Typ;

 

[KARL DEWEY]

Change pivot line to this --
PIVOT tblMaster.Typ IN("Continue", "New", "Transfer");