If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL / Access Pivot and Totals Issue

Options

26-08-2008 3:14pm

Altheus

Registered Users Posts: 1,015 ✭✭✭

Join Date: October 2002

Posts: 905

Hey I'm having trouble working this one out. I'm trying to do a count of the totals for each Status/..

SQL= "TRANSFORM Count(*) 
SELECT CallList FROM callsTable 
GROUP BY CallList 
PIVOT Status IN ('Complete','Worked','Open','Other','New');"

What I have

CallList    Compl Wor   Open    Other    New
Biz_Dev   244    187    21    32    1466
Other      172    33      5    2    
PS          250    343    35    63    867

What I want

CallList    Comple  Worked    Open    Other    New

Biz_Dev        244    187    21    32    1466
Other        172    33    5    2    
PS        250    343    35    63    867
Totals        666    563    61    97    2333