Column totals in a crosstab

[alid]

Hi folks,

I have a simple crosstab query in which I want to sum the columns. I can switch the totals on manually using the ribbon. How do I get them to appear automatically. Thank you for your help.

My query is as follows:

TRANSFORM Count(tblChats.ID) AS CountOfID

SELECT tblStaff.Initials, Count(tblChats.ID) AS [Total Of ID]

FROM tblStaff RIGHT JOIN (tblOutcome RIGHT JOIN tblChats ON tblOutcome.ID = tblChats.Outcome) ON tblStaff.ID = tblChats.Initials

WHERE (((tblChats.Today) Between Now()+1 And Now()-7))

GROUP BY tblStaff.Initials

PIVOT tblOutcome.Outcome;

 

[JHB]

Sorry - I don't think you can that.

 

[alid]

That's unfortunate. Thanks for the reply though.

 

[CJ_London]

have you tried saving the query once you have selected the totals?