I have the following query that returns the total number of calls that occurred on a single date and which phone trunk those calls were placed on (CO).
I have been Googling this for about an hour and am just more confused. I simply need to sort the results by trunk number (CO) correctly.
When I run the query, it returns results with the trunk numbers like this:
and I would like it to be like this:
I would also like the date to be a variable if it requires rewriting this query completely, can you add that in? If it's just adding some sort of sorting line than I can figure out how to make the date a variable on my own.
Thanks in advance!
SELECT `CO` AS Expr1, Count(`Extension`) AS [count]
WHERE (((AllInfo.Date)=#10/10/2008#) AND ((AllInfo.IO)='OUT'))
GROUP BY `CO`
ORDER BY CO;