Hi - I have tried to follow all of the advice I can find but still getting problems with this...
I have tried removing the AS element but still get the same issue
The Query
SELECT diaUsrName AS Agent, diaResponse AS Response, count(*) AS Calls
FROM [AcardaOutbound].[dbo].[CallHistory]
GROUP BY diaUsrName, diaResponse
Order By diaUsrName
Returns the following
admin Already Contacted 1
ADMIN Donated 8
admin Hanged Up 1
admin Information Pack 10
admin Not Interested 4
admin Sale Made 1
arron Information Pack 1
arron Not Interested 1
edward Invalid Number 2
edward Not Interested 1
fred Annual Leave 1
fred IT Outsourced 1
jacinta Ineligible 1
jacinta Information Pack 1
keith Sent Information 3
mary Sent Information 1
natalie IT Outsourced 1
sally Donated 1
sally Free Quote 1
sally Hung Up 1
sally Not Interested 1
seth Information Pack 1
seth Not Interested 1
Any help much appreciated.....
Chris