Report or Query? Totalling columns in X-tab query

[1eyedjack]

Hi all

I have a report based on a crosstab query whose code is:

TRANSFORM Count(Q_Tasks_SATRs_OS.ID_Tasks) AS CountOfID_Tasks
SELECT Q_Tasks_SATRs_OS.Tax, Count(Q_Tasks_SATRs_OS.ID_Tasks) AS [Total Of ID_Tasks]
FROM Q_Tasks_SATRs_OS
GROUP BY Q_Tasks_SATRs_OS.Tax
PIVOT Q_Tasks_SATRs_OS.Partner;

This works perfectly except for one shortcoming: I want totals to be calculated and displayed for each displayed column. Of course I already get the totals by row. Should the totals be calculated in the query or in the report, and how?

Thanks.