grouping by date in a query

  • Thread starter Thread starter Emily
  • Start date Start date
E

Emily

I have set up a query to show me all my employees and
total number of calls each made during the week. Example:
John 15
Mary 20
Amy 30

I want to see how many calls each person made by day.

Monday Tuesday Wednesday
John 5 5 5
Mary 20 0 0
Amy 10 20 0

Does anyone know how to do this? I know I've done
something similar before, but I can't figure it out.
 
-----Original Message-----
I have set up a query to show me all my employees and
total number of calls each made during the week. Example:
John 15
Mary 20
Amy 30

I want to see how many calls each person made by day.

Monday Tuesday Wednesday
John 5 5 5
Mary 20 0 0
Amy 10 20 0

Does anyone know how to do this? I know I've done
something similar before, but I can't figure it out.
.
Make a query with the name, date and call fields, make it
Click to expand...
a sum query( View/Totals). In the Total section of the
fields Sum the Call field , Group By on the Date and Name
fields.
 
Hi Emily,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

You should be able to do that with a cross-tab query where the columns are
the date field, the employee's are the row and some calculation is the
value.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top