So I have been working on this for 2 days now, and I am almost completly stuck.
I have a table Log_Main
Each record in the table represents a call that came into our office. Each record contains a Task_ID (Pri Key), a User_ID, a Call_Date, and other irrelivant data.
I need the query to count the number of calls each user has taken per day.. I got that part, here is the query for that.
SELECT Log_Main.User_ID, Log_Main.Call_Date, Count(*) AS Call_Count
GROUP BY Log_Main.User_ID, Log_Main.Call_Date
ORDER BY Log_Main.User_ID
now from this data I want to select a distinct date, the user with the most calls for that day, and the number of calls.
any help would be appreciated
thanks in advance.