PivotTable total columns are blank. Can I make report based on PivotTable query?

S

Song Su

1st questin: When I run my PivotTable query, total columns and total row are
blank. Only details show numbers.

SELECT qryUniqAll.YYYY,
IIf([course].[SEM]="0","WI",IIf([course].[sem]="1","SP",IIf([course].[SEM]="2","SU","FA")))
AS Semester, qryUniqAll.SUBJ, Sum(qryUniqAll.ENR) AS ENROfSum
FROM qryUniqAll
GROUP BY qryUniqAll.YYYY,
IIf([course].[SEM]="0","WI",IIf([course].[sem]="1","SP",IIf([course].[SEM]="2","SU","FA"))),
qryUniqAll.SUBJ;


My 2nd question is, how to make report based on PivotTable query?
 
Top