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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex Query not working on report 3
IIf in a report based on select query -- problem w/parameters 2
Adding two items on report to get a sum of both 1
iif functin in report 5
CrossTab report "super" columns 5
optimized way to make a report? 14
Count query in report field 1
Solution to tricky problem of showing exactly Top N rows in Pivottable 0

Top