Report Summed by Date

[depawl]

I'm trying to create a report for my organization that sums the amount of material used by date. For example, I have five separate locations in my organization that all consume the same material. It gets reported separately by location. I need to know the total material consumed each day. Then I need to sort that daily total from largest to smallest quantity used. I've tried to do it in a query, and also by summing/grouping in a report. I thought this would be fairly straight forward, but no success as yet.
Thanks.

 

[plog]

Post sample data from your table, then post what you would like as the resulting output to be based on that sample data. Be sure to include table and field names, use this format:

TableNameHere
Field1Name, Field2Name, Field3Name
David, 136, 5/1/2009
Larry, 44, 7/18/2009
Sally, 4/4/2007

 

[depawl]

I've attached a screenshot of my Table. What I need to do is total the Quantity field for each day (for example on 10/24/2013 Location 1 used 113 units and Location 2 used 3.5 units for a total of 116.5). Then when I have a total for each day, I need to sort that total, so that for example I can find the maximum amount of material used in a day.
Thanks.

 

[plog]

You would need a simple aggregate query. Check out this tutorial: http://www.599cd.com/tips/access/aggregate-query/ and this reference site: http://www.techonthenet.com/access/functions/numeric/sum.php

 

[depawl]

Thanks, got it. My problem was I was including too many fields in my aggregate query.