SQL in access - trying to add a total column

[Mariyka1]

Hello,

I have the following code in Access Query.

TRANSFORM count([BZsite Key]) AS [count]
SELECT [BBRM Flag]
FROM B2B_Groupings_Extract
GROUP BY [BBRM Flag]
PIVOT Private_Banking;

This gives me the count by the groupings - although I am unable to add a column with the total of those counts. Any help with this is greatly appreciated!

 

[Trevor G]

Have you tried the Cross Tab query feature.