|
In response to
"that would have been ORDER BY freq DESC also (it's too early). What's the other query? -- nm"
by
kilboooo
|
here's the whole thing:
Posted by
JaxSean (aka JaxSean)
Oct 28 '08, 07:24
|
keep in mind, I'm working in Access.
I have a table with data, that has 3 fields I'm querying: NAME, APPLICATION, and CALL_ID.
I'm currently running 2 queries that are joined and grouped by name, and give me the number of calls taken (by name), and the number of calls 'escalated' (by name). However, they take calls on few different APPLICATIONS, but I want to get the name of the application that they get the most calls on.
so right now, my (access sql) query is:
SELECT helpdesk_escalatedcount.[Taken By], helpdesk_notescalatedcount.LevelOneCalls, helpdesk_escalatedcount.LevelTwoCalls, [LevelTwoCalls]/[LevelOneCalls] AS PercentEscalated
FROM helpdesk_escalatedcount
INNER JOIN
helpdesk_notescalatedcount ON helpdesk_escalatedcount.[Taken By] = helpdesk_notescalatedcount.[Taken By];
now I've got to figure out how to add the other sql I asked about for each [Taken By] (which is the NAME).
|